[COMMITTERS] pgsql: Avoid excessive Hot Standby feedback messages.

2011-03-01 Thread Robert Haas
Avoid excessive Hot Standby feedback messages. Without this patch, when wal_receiver_status_interval=0, indicating that no status messages should be sent, Hot Standby feedback messages are instead sent extremely frequently. Fujii Masao, with documentation changes by me. Branch -- master Det

[COMMITTERS] pgsql: Update discussion of EXPLAIN to reflect existence of ModifyTable

2011-03-01 Thread Tom Lane
Update discussion of EXPLAIN to reflect existence of ModifyTable nodes. Back-patch to 9.0, since this was changed then. Branch -- REL9_0_STABLE Details --- http://git.postgresql.org/pg/commitdiff/82a0e3522205266601966560b398b6ac42731567 Modified Files -- doc/src/sgml/perform

[COMMITTERS] pgsql: Include the target table in EXPLAIN output for ModifyTable nodes

2011-03-01 Thread Tom Lane
Include the target table in EXPLAIN output for ModifyTable nodes. Per discussion, this seems important for plans involving writable CTEs, since there can now be more than one ModifyTable node in the plan. To retain the same formatting as for target tables of scan nodes, we show only one target ta

[COMMITTERS] pgsql: Update discussion of EXPLAIN to reflect existence of ModifyTable

2011-03-01 Thread Tom Lane
Update discussion of EXPLAIN to reflect existence of ModifyTable nodes. Back-patch to 9.0, since this was changed then. Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/09b49a8439fde63826f93f55430868cf2585644b Modified Files -- doc/src/sgml/perform.sgml |

[COMMITTERS] pgsql: Dump the COLLATABLE attribute in CREATE TYPE

2011-03-01 Thread Peter Eisentraut
Dump the COLLATABLE attribute in CREATE TYPE This was previously omitted by accident. Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/16143d64513e4dc3c72bad7ae98d3df0b5a23013 Modified Files -- src/bin/pg_dump/pg_dump.c | 35

[COMMITTERS] pgsql: Fix bugs in Serializable Snapshot Isolation.

2011-03-01 Thread Heikki Linnakangas
Fix bugs in Serializable Snapshot Isolation. Change the way UPDATEs are handled. Instead of maintaining a chain of tuple-level locks in shared memory, copy any existing locks on the old tuple to the new tuple at UPDATE. Any existing page-level lock needs to be duplicated too, as a lock on the new

[COMMITTERS] pgsql: Change pg_last_xlog_receive_location() not to move backwards. Th

2011-03-01 Thread Heikki Linnakangas
Change pg_last_xlog_receive_location() not to move backwards. That makes it a lot more useful for determining which standby is most up-to-date, for example. There was long discussions on whether overwriting existing existing WAL makes sense to begin with, and whether we should do some more extensiv

[COMMITTERS] npgsql - Npgsql2: In Multi-threaded applications there is a race

2011-03-01 Thread User Fxjr
Log Message: --- In Multi-threaded applications there is a race condition that can occur which will result in a broken connection being re-added to the pool. Thanks David Leaver for patches. More information here: http://pgfoundry.org/forum/forum.php?thread_id=10067&forum_id=519 Modif

[COMMITTERS] pgsql: Additional PL/Python regression test expected file

2011-03-01 Thread Peter Eisentraut
Additional PL/Python regression test expected file plpython_subtransaction test needs a separate expected file specifically for Python 2.5. Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/2f363590c17c0e02186efab5fa0b197b82a5b3ae Modified Files -- src/pl/

[COMMITTERS] pgsql: Fix plpython breakage detected on certain Fedora machines on bui

2011-03-01 Thread Andrew Dunstan
Fix plpython breakage detected on certain Fedora machines on buildfarm. Patch from Jan Urbański. Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/4c966d920fb75a5d0366b887c2ef28e6d87c1eda Modified Files -- src/pl/plpython/plpython.c |1 + 1 files change

[COMMITTERS] npgsql - Npgsql2: Added patches for connection leaks in tests.

2011-03-01 Thread User Fxjr
Log Message: --- Added patches for connection leaks in tests. Thanks David Leaer. Added test for double value support. Modified Files: -- Npgsql2/testsuite/noninteractive/NUnit20: CommandTests.cs (r1.42 -> r1.43) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.