aboutsummaryrefslogtreecommitdiff
Commit message (Collapse)AuthorAge
* Consistent capitalizationPeter Eisentraut2007-11-07
|
* Improve wordingPeter Eisentraut2007-11-07
|
* Specify putting two spaces after sentence-ending period, which is currentPeter Eisentraut2007-11-07
| | | | practice also.
* Error message cleanupPeter Eisentraut2007-11-07
|
* Use "alternative" instead of "alternate" where it is clearer.Peter Eisentraut2007-11-07
|
* Fixed two parser bugs.Michael Meskes2007-11-06
|
* Some code review for xml.c:Tom Lane2007-11-06
| | | | | | | | | | | | | | Add some more xml_init() calls that might not be necessary, but seem like a good idea to avoid possible problems like we saw in xmlelement(). Fix unsafe assumption that you can keep using the tupledesc of a relcache entry you don't have open. Add missing error checks for SearchSysCache failure. Get rid of handwritten array traversal in xpath() and O(N^2), broken-for-nulls array access code in map_sql_value_to_xml_value(), in favor of using deconstruct_array. Manually adjust a lot of line breaks in places where the code is otherwise gonna look pretty awful after pg_indent hacks it up (original author seems to have liked to lay out code for a 200-column window).
* Fix xmlelement() to initialize libxml correctly before using it, and to avoidTom Lane2007-11-05
| | | | | | | | | | assuming that evaluation of its input expressions won't change the state of libxml. This requires refactoring xml_init() to not call xmlInitParser(), since now not all of its callers want that. I also tweaked things to avoid repeated execution of one-time-only tests inside xml_init(), though this is mostly for clarity rather than in hopes of saving any noticeable amount of runtime. Per report from Sheikh Amjad and subsequent discussion. In passing, fix a couple of inadequately schema-qualified queries.
* Fix deprecated-by-C-spec usage: storage class should come before constTom Lane2007-11-05
| | | | decoration. Zdenek Kotala
* Improve conversion of legacy CREATE CONSTRAINT TRIGGER representation ofTom Lane2007-11-05
| | | | | | | | | | | | | | | | | | foreign keys, one more time. Insist on matching up all three triggers before we create a constraint; this will avoid creation of duplicate constraints in scenarios where a broken FK constraint was repaired by re-adding the constraint without removing the old partial trigger set. Basically, this will work nicely in all cases where the FK was actually functioning correctly in the database that was dumped. It will fail to restore an FK in just one case where we theoretically could restore it: where we find the referenced table's triggers and not the referencing table's trigger. However, in such a scenario it's likely that the user doesn't even realize he still has an FK at all (since the more-likely-to-fail cases aren't enforced), and we'd probably not accomplish much except to cause the reload to fail because the data doesn't meet the FK constraint. Also make the NOTICE logging still more verbose, by adding detail about which of the triggers were found. This seems about all we can do without solving the problem of getting the user's attention at session end.
* Document that configure option only affects contrib:Bruce Momjian2007-11-05
| | | | --with-ossp-uuid use OSSP UUID library when building /contrib/uuid-ossp
* Minor editorial improvements to txid functions' documentation: put backTom Lane2007-11-05
| | | | | some text that got dropped, improve markup, improve descriptions of snapshot components.
* Document that syncronhous commit can be turned off in a singleBruce Momjian2007-11-05
| | | | multi-statement transaction.
* Properly pass third argument to open() in fsync test program.Bruce Momjian2007-11-05
| | | | Hiroshi Saito
* Remove <sect1> of txid functions.Bruce Momjian2007-11-05
|
* Move txid snapshot field description table from datatype to functions section.Bruce Momjian2007-11-05
|
* Fix typos.Magnus Hagander2007-11-05
| | | | Guillaume Lelarge
* Document txid functions.Bruce Momjian2007-11-05
| | | | Marko Kreen
* Add a note about another issue that needs to be considered beforeTom Lane2007-11-05
| | | | changing the TOAST size thresholds.
* Remove deprecation notice and add comment about safely restoring backups.D'Arcy J.M. Cain2007-11-05
| | | | As per discussion on hackers.
* Use LOG instead of DEBUG2 for logging invalid cancel requests. (That is,Neil Conway2007-11-05
| | | | | cancel requests with an incorrect key, or with a non-existent PID). Per recent discussion on -hackers.
* Working improvement.Bruce Momjian2007-11-04
|
* Add link to NFS section from "creating a database cluster.Bruce Momjian2007-11-04
|
* Document possible problems with NFS tablespaces.Bruce Momjian2007-11-04
|
* Minor improvements to code for converting legacy CREATE CONSTRAINT TRIGGERTom Lane2007-11-04
| | | | | | | | | | | commands into proper foreign-key constraints. Believe the constraint name given in the trigger arguments in preference to the trigger name --- to judge from Olivier Prenant's example, pg_dump must at some time have used the autogenerated trigger name there, though AFAICT no current release branch tip does. Improve the emitted NOTICEs to provide more detail (PK table's name and column names). Handle the case where pg_dump forgot to provide the FROM table (a bug that never did get fixed in 7.0.x apparently). This commit doesn't do anything about the question of what to do with incomplete trigger groups.
* Properly indent tablespace SGML section.Bruce Momjian2007-11-04
|
* Mention "replication" in the title of the high availability and loadBruce Momjian2007-11-04
| | | | | balancing chapter because some people were looking for 'replication' and didn't realize that chapter addressed it.
* Update wording for xsl configure option.Bruce Momjian2007-11-04
|
* Document that configure --with-libxslt controls just /contrib/xml2.Bruce Momjian2007-11-04
| | | | Nikolay Samokhvalov
* Prevent continuing disk-space bloat when profiling (with PROFILE_PID_DIRTom Lane2007-11-04
| | | | | | | | | | enabled) and autovacuum is on. Since there will be a steady stream of autovac worker processes exiting and dropping gmon.out files, allowing them to make separate subdirectories results in serious bloat; and it seems unlikely that anyone will care about those profiles anyway. Limit the damage by forcing all autovac workers to dump in one subdirectory, PGDATA/gprof/avworker/. Per report from Jšrg Beyer and subsequent discussion.
* Teach CREATE CONSTRAINT TRIGGER to convert old-style foreign keyTom Lane2007-11-04
| | | | | | | | trigger definitions into regular foreign key constraints. This seems necessary given that some people evidently never did get around to running adddepend on their schemas, and without some sort of hack the old definitions will no longer work. Per report from Olivier Prenant and subsequent investigation.
* Ensure that EquivalenceClasses generated from ORDER BY keys contain properTom Lane2007-11-02
| | | | | | | | | RelabelType nodes when the sort key is binary-compatible with the sort operator rather than having exactly its input type. We did this correctly for index columns but not sort keys, leading to failure to notice that a varchar index matches an ORDER BY request. This requires a bit more work in make_sort_from_pathkeys, but not anyplace else that I can find. Per bug report and subsequent discussion.
* Mention that internal hash functions changed in 8.3 release notes.Bruce Momjian2007-11-01
|
* Some corrections/improvements to new acronym list.Tom Lane2007-11-01
|
* Update discussion of shared memory sizing for 8.3: adjust multipliers,Tom Lane2007-11-01
| | | | mention autovacuum_max_workers. Minor copy-editing too.
* Update Czech FAQ.Bruce Momjian2007-11-01
| | | | Pavel Stehule
* Acronym spelling fix.Bruce Momjian2007-11-01
|
* Add documentation mention that FSM == Free Space Map, so the configBruce Momjian2007-11-01
| | | | parameter name makes more sense.
* Add acronym section to our documentation.Bruce Momjian2007-11-01
|
* Add:Bruce Momjian2007-10-31
| | | | | > * Prevent long-lived temporary tables from causing frozen-Xid advancement > starvation
* More precise error messagePeter Eisentraut2007-10-31
|
* removed from CVSMarc G. Fournier2007-10-30
|
* Add note on PostgreSQL vs. Postgres.Peter Eisentraut2007-10-30
|
* Update some obsolete stuff in the GRANT and REVOKE reference pages:Tom Lane2007-10-30
| | | | | simplify the syntax examples by unifying user and group cases, and fix no-longer-correct example of psql \z output. Per Erwin Brandstetter.
* Add a note pointing out that some other databases make GREATEST andTom Lane2007-10-30
| | | | | LEAST handle NULL arguments differently than we do. Per a discussion on 30-Jun that somehow didn't get done.
* simple script to pull together a very small (<500k) tar file that buildsMarc G. Fournier2007-10-30
| | | | | | | | | *just* libpq ... its not perfect, as it pulls in more files then is necessarily required to build, but as it is, it requires one simple patch to configure.in in order to work ... Tested on FreeBSD ... patch for configure.in hasn't been applied, but putting the script in place so that it doesn't get lost ...
* In the previous commit message, I forgot to credit Simon Riggs who providedAlvaro Herrera2007-10-29
| | | | the patch, which I modified only slightly before applying.
* Mention the index name in 'could not create unique index' errors,Tom Lane2007-10-29
| | | | per suggestion from Rene Gollent.
* Remove the hack in the grammar that "optimized away" DEFAULT NULL clauses.Tom Lane2007-10-29
| | | | | | | | | | | | | | | Instead put in a test to drop a NULL default at the last moment before storing the catalog entry. This changes the behavior in a couple of ways: * Specifying DEFAULT NULL when creating an inheritance child table will successfully suppress inheritance of any default expression from the parent's column, where formerly it failed to do so. * Specifying DEFAULT NULL for a column of a domain type will correctly override any default belonging to the domain; likewise for a sub-domain. The latter change happens because by the time the clause is checked, it won't be a simple null Const but a CoerceToDomain expression. Personally I think this should be back-patched, but there doesn't seem to be consensus for that on pgsql-hackers, so refraining.
* - Add check of already changed page while replay WAL. This touches onlyTeodor Sigaev2007-10-29
| | | | | | | | | | | | | ginRedoInsert(), because other ginRedo* functions rewrite whole page or make changes which could be applied several times without consistent's loss - Remove check of identifying of corresponding split record: it's possible that replaying of WAL starts after actual page split, but before removing of that split from incomplete splits list. In this case, that check cause FATAL error. Per stress test which reproduces bug reported by Craig McElroy <craig.mcelroy@contegix.com>
generated by cgit v1.2.3 (git 2.25.1) at 2025-08-02 20:59:09 +0000