summaryrefslogtreecommitdiff
AgeCommit message (Collapse)Author
2005-09-16Add:Bruce Momjian
> o Fix SELECT INTERVAL '1' MONTH
2005-09-16Adjust regression for new cancel query message.Bruce Momjian
2005-09-16Update query cancel message:Bruce Momjian
errmsg("canceling query due to user request or statement timeout")));
2005-09-16Adjust bcc to work for thread changes.Bruce Momjian
2005-09-16This correction is required of nmake of Windows.Bruce Momjian
Hiroshi Saito
2005-09-16Update numbering.Bruce Momjian
Michael Fuhr
2005-09-16Add:Bruce Momjian
< > * Update Bonjour to work with newer cross-platform SDK
2005-09-16tag it all beta2 ...REL8_1_0BETA2PostgreSQL Daemon
2005-09-16Update wording:Bruce Momjian
< 390d388 < 453c451 < removed or have its heap and index files truncated. One > be removed or have its heap and index files truncated. One < * Use a phantom command counter for nested subtransactions to reduce < per-tuple overhead
2005-09-16Small fixesTeodor Sigaev
2005-09-16Add:Bruce Momjian
> o Add single-step debugging of PL/PgSQL functions
2005-09-16Rename pg_complete_relation_size() to pg_total_relation_size(), for theNeil Conway
sake of brevity and clarity. Make pg_reload_conf(), pg_rotate_logfile(), and pg_cancel_backend() return a boolean rather than an integer to indicate success or failure. Along the way, make some minor cleanups to dbsize.c -- in particular, use elog() rather than ereport() for "shouldn't happen" error conditions, and remove some of the more flagrant violations of the Postgres indentation conventions. Catalog version bumped.
2005-09-16Update two comments to refer to use the new list API names.Neil Conway
2005-09-16Update release notes for changes between beta1 and beta2.Tom Lane
2005-09-16Add note about pg_autovacuum settings not being saved on a dump, perAlvaro Herrera
Robert Treat.
2005-09-16Force the size and alignment of LWLock array entries to be either 16 or 32Tom Lane
bytes. This shouldn't make any difference on x86 machines, where the size happened to be 16 bytes anyway, but on 64-bit machines and machines with slock_t int or wider, it will speed array indexing and hopefully reduce SMP cache contention effects. Per recent experimentation.
2005-09-15Copy-editing for GiST README.Neil Conway
2005-09-15Readme about GiST's algorithmsTeodor Sigaev
2005-09-151 Update Snowball sourcesTeodor Sigaev
2 Makefile fixes
2005-09-14Various documentation improvements. Add a lot of index entries forNeil Conway
the builtin functions (although some more entries are still needed), and remove the duplicate index entries that have been causing collateindex.pl warnings. Consistently use "int" and "bigint", rather than a mix of "int", "integer", "int4", "bigint", and "int8". Make parenthesis style in syntax examples more consistent. Various copy-editing for newly-added documentation and SGML markup fixes.
2005-09-14Tweak the PL/PgSQL regression tests to catch the recently reported bugNeil Conway
in parsing cursor declarations.
2005-09-14Fix recent breakage of decl_cursor_arglist syntax, per Michael Paesold.Tom Lane
2005-09-13Fix make_tuple_from_row to support nested rowtypes, per gripe fromTom Lane
Roman Neuhauser. Update some obsolete comments for exec_eval_datum, too.
2005-09-13Minor SGML markup fixes.Neil Conway
2005-09-13Document the new autovacuum daemon.Alvaro Herrera
2005-09-12Fix cut-and-paste-o in TCP keepalives documentation.Tom Lane
2005-09-12Minor documentation tweak: make the capitalization of a section titleNeil Conway
consistent with the other sections in this chapter.
2005-09-12Ensure that any memory leaked during an error inside the bgwriter isTom Lane
recovered. I did not see any actual leak while testing this in CVS tip, but 8.0 definitely has a problem with leaking the space temporarily palloc'd by BufferSync(). In any case this seems a good idea to forestall similar problems in future. Per report from Arjen van der Meijden.
2005-09-12Make the documentation of GUC variables a separate chapter, rather thanNeil Conway
a section of the "Server Run-time Environment" chapter. Also, move the SGML for the new chapter to a separate file and fix the resulting fallout.
2005-09-12Update manual's introduction to indexes to reflect 8.1 changes; inTom Lane
particular the addition of bitmap scans and the relaxation of rules about when multicolumn indexes can be used. Also some minor editorial work in other parts of the chapter.
2005-09-12Fix a mistake in the documentation for SPI_getbinval(), per Michael Fuhr.Neil Conway
2005-09-12Forgot to add pg_pltemplate to the list of shared system catalogs thatTom Lane
appears in the REINDEX ref page.
2005-09-12Fixed transaction command handling to not ignore savepoints and to correctly ↵Michael Meskes
check for errors.
2005-09-12Add a few items to the release notes, and make a few more minor cleanups.Neil Conway
2005-09-12Tweak TCP-keepalive code so that an invalid setting doesn't cause usTom Lane
to drop connections unceremoniously. Also some other marginal cleanups: don't query getsockopt() repeatedly if it fails, and avoid having the apparent definition of struct Port depend on which system headers you might have included or not. Oliver Jowett and Tom Lane.
2005-09-11Many small improvements and copy edits to the release notes. Use "&mdash;"Neil Conway
rather than "-" for the "dash" character. Correct SGML markup. Make references to the names of contributors more consistent. Rewrite a bit of prose, and make some other similar cleanups.
2005-09-11Fix some corner-case bugs in _sendSQLLine's parsing of SQL commandsTom Lane
> found in a pg_dump archive. It had problems with dollar-quote tags broken across bufferload boundaries (this may explain bug report from Rod Taylor), also with dollar-quote literals of the form $a$a$..., and was also confused about the rules for backslash in double quoted identifiers (ie, they're not special). Also put in placeholder support for E'...' literals --- this will need more work later.
2005-09-11Avoid changing stdin/stdout to binary mode on Windows unless that isTom Lane
really the source or destination of the archive. I think this will resolve recent complaints that password prompting is broken in pg_restore on Windows. Note that password prompting and reading from stdin is an unworkable combination on Windows ... but that was true anyway.
2005-09-10Update URL for FAQ_MINGW.Bruce Momjian
2005-09-09Given its current definition that depends on time(NULL), timetz_zoneTom Lane
is certainly no longer immutable, but must indeed be marked volatile. I wonder if it should use the value of now() (that is, transaction start time) so that it could be marked stable. But it's probably not important enough to be worth changing the code for ... indeed, I'm not even going to force an initdb for this catalog change, seeing that we just did one a few hours ago.
2005-09-09timestamptz_izone should return the input, not NULL, when the inputTom Lane
is a non-finite timestamp, for consistency with related functions. In other words: +infinity rotated to a different timezone is still +infinity.
2005-09-09Fix the various forms of AT TIME ZONE to accept either timezones foundTom Lane
in the zic database or zone names found in the date token table. This preserves the old ability to do AT TIME ZONE 'PST' along with the new ability to do AT TIME ZONE 'PST8PDT'. Per gripe from Bricklen Anderson. Also, fix some inconsistencies in usage of TZ_STRLEN_MAX --- the old code had the potential for one-byte buffer overruns, though given alignment considerations it's unlikely there was any real risk.
2005-09-08Create the pg_pltemplate system catalog to hold template informationTom Lane
for procedural languages. This replaces the hard-wired table I had originally proposed as a stopgap solution. For the moment, the initial contents only include languages shipped with the core distribution.
2005-09-08Update regression tests for new USA timezone data. Mea culpa for notTom Lane
realizing that the regression tests could be affected.
2005-09-07Update timezone data files to release 2005m of the zic database.Tom Lane
Among other changes, this reflects the recently passed change in USA daylight savings rules.
2005-09-05Implement a preliminary 'template' facility for procedural languages,Tom Lane
as per my recent proposal. For now the template data is hard-wired in proclang.c --- this should be replaced later by a new shared system catalog, but we don't want to force initdb during 8.1 beta. This change lets us cleanly load existing dump files even if they contain outright wrong information about a PL's support functions, such as a wrong path to the shared library or a missing validator function. Also, we can revert the recent kluges to make pg_dump dump PL support functions that are stored in pg_catalog. While at it, I removed the code in pg_regress that replaced $libdir with a hardcoded path for temporary installations. This is no longer needed given our support for relocatable installations.
2005-09-05Back out prior patch and instead just suppress SubqueryScan eliminationTom Lane
when there are extra resjunk columns in the child node. I found some additional cases involving Append nodes that weren't handled by the prior patch, and it's not clear how to fix them in the same way without breaking inheritance cases. So the prudent path seems to be to narrow the scope of the optimization.
2005-09-05Clean up version comparison/display code, per gripe from Michael Fuhr.Tom Lane
2005-09-05For non-projecting plan node types such as Limit, set_plan_referencesTom Lane
has to recopy the input plan node's targetlist if it removes a SubqueryScan node just below the non-projecting node. For simplicity I made it recopy always. Per bug report from Allan Wang and Michael Fuhr.
2005-09-05Add a note about CSV lines with trailing spaces.Andrew Dunstan
Suggestion by Darcy Buskermolen, reworded by me.