- 07 Nov, 2007 2 commits
-
-
Peter Eisentraut authored
-
Peter Eisentraut authored
-
- 06 Nov, 2007 2 commits
-
-
Michael Meskes authored
-
Tom Lane authored
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).
-
- 05 Nov, 2007 14 commits
-
-
Tom Lane authored
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.
-
Tom Lane authored
decoration. Zdenek Kotala
-
Tom Lane authored
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.
-
Bruce Momjian authored
--with-ossp-uuid use OSSP UUID library when building /contrib/uuid-ossp
-
Tom Lane authored
some text that got dropped, improve markup, improve descriptions of snapshot components.
-
Bruce Momjian authored
multi-statement transaction.
-
Bruce Momjian authored
Hiroshi Saito
-
Bruce Momjian authored
-
Bruce Momjian authored
-
Magnus Hagander authored
Guillaume Lelarge
-
Bruce Momjian authored
Marko Kreen
-
Tom Lane authored
changing the TOAST size thresholds.
-
D'Arcy J.M. Cain authored
As per discussion on hackers.
-
Neil Conway authored
cancel requests with an incorrect key, or with a non-existent PID). Per recent discussion on -hackers.
-
- 04 Nov, 2007 10 commits
-
-
Bruce Momjian authored
-
Bruce Momjian authored
-
Bruce Momjian authored
-
Tom Lane authored
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.
-
Bruce Momjian authored
-
Bruce Momjian authored
balancing chapter because some people were looking for 'replication' and didn't realize that chapter addressed it.
-
Bruce Momjian authored
-
Bruce Momjian authored
Nikolay Samokhvalov
-
Tom Lane authored
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 Jrg Beyer and subsequent discussion.
-
Tom Lane authored
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.
-
- 02 Nov, 2007 1 commit
-
-
Tom Lane authored
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.
-
- 01 Nov, 2007 7 commits
-
-
Bruce Momjian authored
-
Tom Lane authored
-
Tom Lane authored
mention autovacuum_max_workers. Minor copy-editing too.
-
Bruce Momjian authored
Pavel Stehule
-
Bruce Momjian authored
-
Bruce Momjian authored
parameter name makes more sense.
-
Bruce Momjian authored
-
- 31 Oct, 2007 2 commits
-
-
Bruce Momjian authored
> * Prevent long-lived temporary tables from causing frozen-Xid advancement > starvation
-
Peter Eisentraut authored
-
- 30 Oct, 2007 2 commits
-
-
Marc G. Fournier authored
removed from CVS
-
Peter Eisentraut authored
-