[COMMITTERS] pgsql: When building with LWLOCK_STATS, initialize the stats in LWLockW

When building with LWLOCK_STATS, initialize the stats in LWLockWaitUntilFree. If LWLockWaitUntilFree was called before the first LWLockAcquire call, you would either crash because of access to uninitialized array or account the acquisition incorrectly. LWLockConditionalAcquire doesn't have this pr

[COMMITTERS] pgsql: createuser: Disable prompting by default

createuser: Disable prompting by default Do not prompt when options were not specified. Assume --no-createdb, --no-createrole, --no-superuser by default. Also disable prompting for user name in dropdb, unless --interactive was specified. reviewed by Josh Kupershmidt Branch -- master Detai

[COMMITTERS] pgsql: pg_dump: Further reduce reliance on global variables.

pg_dump: Further reduce reliance on global variables. This is another round of refactoring to make things simpler for parallel pg_dump. pg_dump.c now issues SQL queries through the relevant Archive object, rather than relying on the global variable g_conn. This commit isn't quite enough to get r

[COMMITTERS] pgsql: Add TIMING option to EXPLAIN, to allow eliminating of timing ove

Add TIMING option to EXPLAIN, to allow eliminating of timing overhead. Sometimes it may be useful to get actual row counts out of EXPLAIN (ANALYZE) without paying the cost of timing every node entry/exit. With this patch, you can say EXPLAIN (ANALYZE, TIMING OFF) to get that. Tomas Vondra, review

[COMMITTERS] pgsql: Add a transform function for numeric typmod coercisions.

Add a transform function for numeric typmod coercisions. This enables ALTER TABLE to skip table and index rebuilds when a column is changed to an unconstrained numeric, or when the scale is unchanged and the precision does not decrease. Noah Misch, with a few stylistic changes and a fix for an OI

[COMMITTERS] pgsql: Add a transform function for varbit typmod coercisions.

Add a transform function for varbit typmod coercisions. This enables ALTER TABLE to skip table and index rebuilds when the new type is unconstraint varbit, or when the allowable number of bits is not decreasing. Noah Misch, with review and a fix for an OID collision by me. Branch -- master

[COMMITTERS] pgsql: Support fls().

Support fls(). The immediate impetus for this is that Noah Misch's patch to elide unnecessary table and index rebuilds when changing typmod for temporal types uses it; and this is extracted from that patch, with some further commentary by me. But it seems logically separate from the remainder of

[COMMITTERS] pgsql: Fix typo in comment.

Fix typo in comment. Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/5ece8ecae88fd7fd8616429790bd70ca2ffad260 Modified Files -- src/port/fls.c |2 +- 1 files changed, 1 insertions(+), 1 deletions(-) -- Sent via pgsql-committers mailing list (pgsql-c

[COMMITTERS] pgsql: pg_regress: Use target-specific variable instead of overriding m

pg_regress: Use target-specific variable instead of overriding make rule Use a target-specific variable to add to CPPFLAGS instead of writing a custom .c -> .o rule. This will ensure that dependency tracking is used when enabled. Branch -- master Details --- http://git.postgresql.org/pg

[COMMITTERS] pgsql: pg_dump: Add some const qualifiers

pg_dump: Add some const qualifiers Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/e09509bd33d691b2d2d3473b4e112efd59518b31 Modified Files -- src/bin/pg_dump/pg_backup.h |2 +- src/bin/pg_dump/pg_backup_archiver.c |4 ++-- src/bin/pg_dump/p

[COMMITTERS] pgsql: Add opensp as a requirement for building the docs on Debian ---

Add opensp as a requirement for building the docs on Debian --- tested on Debian Squeeze. Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/a870c7fdbca71e2c651fd80b3dec902c49040c7a Modified Files -- doc/src/sgml/docguide.sgml |2 +- 1 files changed, 1 in

[COMMITTERS] pgsql: Fix typos pointed out by Noah Misch.

Fix typos pointed out by Noah Misch. Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/af7dd696b00fe666fec3642e103acafe33002765 Modified Files -- src/backend/utils/adt/numeric.c |4 ++-- 1 files changed, 2 insertions(+), 2 deletions(-) -- Sent via pgs

[COMMITTERS] pgsql: Rename LWLockWaitUntilFree to LWLockAcquireOrWait.

Rename LWLockWaitUntilFree to LWLockAcquireOrWait. LWLockAcquireOrWait makes it more clear that the lock is acquired if it's free. Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/1a01560cbb78ff363fc7d70298328aa23f05bfb5 Modified Files -- src/backend/acce