[COMMITTERS] pgsql: Resolve timing issue with logging locks for Hot Standby.

2012-02-01 Thread Simon Riggs
Resolve timing issue with logging locks for Hot Standby. We log AccessExclusiveLocks for replay onto standby nodes, but because of timing issues on ProcArray it is possible to log a lock that is still held by a just committed transaction that is very soon to be removed. To avoid any timing issue we

[COMMITTERS] pgsql: Resolve timing issue with logging locks for Hot Standby.

2012-02-01 Thread Simon Riggs
Resolve timing issue with logging locks for Hot Standby. We log AccessExclusiveLocks for replay onto standby nodes, but because of timing issues on ProcArray it is possible to log a lock that is still held by a just committed transaction that is very soon to be removed. To avoid any timing issue we

[COMMITTERS] pgsql: Properly free the sslcompression field in PGconn

2012-02-01 Thread Magnus Hagander
Properly free the sslcompression field in PGconn Marko Kreen Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/21238deea50e194bfa1c844b01ffbd15ed56c01a Modified Files -- src/interfaces/libpq/fe-connect.c |2 ++ 1 files changed, 2 insertions(+), 0 deleti

[COMMITTERS] pgsql: Implement dry-run mode for pg_archivecleanup

2012-02-01 Thread Alvaro Herrera
Implement dry-run mode for pg_archivecleanup In dry-run mode, just the name of the file to be removed is printed to stdout; this is so the user can easily plug it into another program through a pipe. If debug mode is also specified, a more verbose message is printed to stderr. Author: Gabriele B

[COMMITTERS] pgsql: Try to be more consistent about accepting denormalized float8 nu

2012-02-01 Thread Tom Lane
Try to be more consistent about accepting denormalized float8 numbers. On some platforms, strtod() reports ERANGE for a denormalized value (ie, one that can be represented as distinct from zero, but is too small to have full precision). On others, it doesn't. It seems better to try to accept the

[COMMITTERS] pgsql: Add some regression test cases for denormalized float8 input.

2012-02-01 Thread Tom Lane
Add some regression test cases for denormalized float8 input. This was submitted with the previous patch, but I'm committing it separately to ease backing it out if these results prove too unportable. Marti Raudsepp, after a proposal by Jeroen Vermeulen Branch -- master Details --- http

[COMMITTERS] pgsql: psql: Case preserving completion of SQL key words

2012-02-01 Thread Peter Eisentraut
psql: Case preserving completion of SQL key words Instead of always completing SQL key words in upper case, look at the word being completed and match the case. reviewed by Fujii Masao Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/69f4f1c3576abc535871c6cfa95539e32

[COMMITTERS] pgsql: initdb: Add options --auth-local and --auth-host

2012-02-01 Thread Peter Eisentraut
initdb: Add options --auth-local and --auth-host reviewed by Robert Haas and Pavel Stehule Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/8a02339e9ba3f2f962c5967be8c5d053a1fa39d2 Modified Files -- doc/src/sgml/ref/initdb.sgml | 31 ++- src/

[COMMITTERS] pgsql: Avoid re-checking for visibility map extension too frequently.

2012-02-01 Thread Robert Haas
Avoid re-checking for visibility map extension too frequently. When testing bits (but not when setting or clearing them), we now won't check whether the map has been extended. This significantly improves performance in the case where the visibility map doesn't exist yet, by avoiding an extra syst