[COMMITTERS] pgsql: Refer to max_wal_senders in a more consistent fashion.

2010-03-31 Thread Robert Haas
Log Message: --- Refer to max_wal_senders in a more consistent fashion. The error message now makes explicit reference to the GUC that must be changed to fix the problem, using wording suggested by Tom Lane. Along the way, rename the GUC from MaxWalSenders to max_wal_senders for

[COMMITTERS] pgsql: Version stamp 9.0alpha5.

2010-03-31 Thread Robert Haas
Log Message: --- Version stamp 9.0alpha5. Tags: REL9_0_ALPHA5_BRANCH Modified Files: -- pgsql: configure (r1.677 - r1.677.2.1) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/configure?r1=1.677r2=1.677.2.1) configure.in (r1.625 - r1.625.2.1)

[COMMITTERS] pgsql: Make smart shutdown work in combination with Hot

2010-04-07 Thread Robert Haas
Log Message: --- Make smart shutdown work in combination with Hot Standby/Streaming Replication. At present, killing the startup process does not release any locks it holds, so we must wait to stop the startup and walreceiver processes until all read-only backends have exited. Without

Re: [COMMITTERS] pgsql: Fix minor typo in comment in xlog.c

2010-04-14 Thread Robert Haas
On Wed, Apr 14, 2010 at 6:29 AM, Simon Riggs sri...@postgresql.org wrote: Log Message: --- Fix minor typo in comment in xlog.c Hmm, I think in this case the correct word would be affect not effect. ...Robert -- Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org)

[COMMITTERS] pgsql: Typo fix.

2010-04-14 Thread Robert Haas
Log Message: --- Typo fix. Kevin Grittner. Modified Files: -- pgsql/src/backend/access/gist: README (r1.4 - r1.5) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/access/gist/README?r1=1.4r2=1.5) -- Sent via pgsql-committers mailing list

[COMMITTERS] pgsql: Provide better guidance for adjusting shared_buffers.

2010-04-16 Thread Robert Haas
Log Message: --- Provide better guidance for adjusting shared_buffers. Modified Files: -- pgsql/doc/src/sgml: config.sgml (r1.266 - r1.267) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/config.sgml?r1=1.266r2=1.267) -- Sent via

Re: [COMMITTERS] pgsql: Provide better guidance for adjusting shared_buffers.

2010-04-16 Thread Robert Haas
On Fri, Apr 16, 2010 at 7:17 PM, David Fetter da...@fetter.org wrote: On Fri, Apr 16, 2010 at 09:46:07PM +, Robert Haas wrote: Log Message: --- Provide better guidance for adjusting shared_buffers. Modified Files: --     pgsql/doc/src/sgml:         config.sgml

[COMMITTERS] pgsql: Provide better guidance for adjusting shared_buffers.

2010-04-18 Thread Robert Haas
Log Message: --- Provide better guidance for adjusting shared_buffers. This change was previously committed to HEAD, but the consensus seems to be in favor of back-patching it. I'm only backpatching as far as 8.3.X, however, because it's not clear to me to what degree this advice applies

[COMMITTERS] pgsql: Provide better guidance for adjusting shared_buffers.

2010-04-18 Thread Robert Haas
Log Message: --- Provide better guidance for adjusting shared_buffers. This change was previously committed to HEAD, but the consensus seems to be in favor of back-patching it. I'm only backpatching as far as 8.3.X, however, because it's not clear to me to what degree this advice applies

[COMMITTERS] pgsql: Add an 'enable_material' GUC.

2010-04-18 Thread Robert Haas
Log Message: --- Add an 'enable_material' GUC. The logic for determining whether to materialize has been significantly overhauled for 9.0. In case there should be any doubt about whether materialization is a win in any particular case, this should provide a convenient way of seeing what

[COMMITTERS] pgsql: Update docs as to when WAL logging can be skipped.

2010-04-19 Thread Robert Haas
Log Message: --- Update docs as to when WAL logging can be skipped. In 8.4 and prior, WAL-logging could potentially be skipped whenever archive_mode=off. With streaming replication, this is now true only if max_wal_senders=0. Fujii Masao, with light copyediting by me Modified Files:

Re: [COMMITTERS] pgsql: Update docs as to when WAL logging can be skipped.

2010-04-19 Thread Robert Haas
On Mon, Apr 19, 2010 at 8:26 PM, Robert Haas rh...@postgresql.org wrote: Log Message: --- Update docs as to when WAL logging can be skipped. In 8.4 and prior, WAL-logging could potentially be skipped whenever archive_mode=off.  With streaming replication, this is now true only

[COMMITTERS] pgsql: Rename standby_keep_segments to wal_keep_segments.

2010-04-20 Thread Robert Haas
Log Message: --- Rename standby_keep_segments to wal_keep_segments. Also, make the name of the GUC and the name of the backing variable match. Alnong the way, clean up a couple of slight typographical errors in the related docs. Modified Files: -- pgsql/doc/src/sgml:

Re: [COMMITTERS] pgsql: Make CheckRequiredParameterValues() depend upon correct

2010-04-23 Thread Robert Haas
On Fri, Apr 23, 2010 at 3:57 PM, Simon Riggs sri...@postgresql.org wrote: Log Message: --- Make CheckRequiredParameterValues() depend upon correct combination of parameters. Fix bug report by Robert Haas that error message and hint was incorrect if wrong mode parameters specified

Re: [HACKERS] Re: [COMMITTERS] pgsql: Make CheckRequiredParameterValues() depend upon correct

2010-04-23 Thread Robert Haas
On Fri, Apr 23, 2010 at 4:44 PM, Tom Lane t...@sss.pgh.pa.us wrote: Simon Riggs si...@2ndquadrant.com writes: No intention of doing that. This change allows people to see what the dependency actually is once the bug has been fixed. Change needs to start from here, not from where we were

Re: [HACKERS] [COMMITTERS] pgsql: Add missing optimizer hooks for function cost and number of rows.

2010-04-23 Thread Robert Haas
On Fri, Apr 23, 2010 at 6:55 PM, Tom Lane t...@sss.pgh.pa.us wrote: sri...@postgresql.org (Simon Riggs) writes: Log Message: --- Add missing optimizer hooks for function cost and number of rows. Closely follow design of other optimizer hooks: if hook exists retrieve value from

[COMMITTERS] pgsql: Fix various instances of the the.

2010-04-23 Thread Robert Haas
Log Message: --- Fix various instances of the the. Two of these were pointed out by Erik Rijkers; the rest I found. Modified Files: -- pgsql/contrib/cube: CHANGES (r1.3 - r1.4)

Re: [HACKERS] Re: [COMMITTERS] pgsql: Add missing optimizer hooks for function cost and number of rows.

2010-04-24 Thread Robert Haas
On Sat, Apr 24, 2010 at 3:31 AM, Simon Riggs si...@2ndquadrant.com wrote: On Fri, 2010-04-23 at 18:55 -0400, Tom Lane wrote: sri...@postgresql.org (Simon Riggs) writes: Log Message: --- Add missing optimizer hooks for function cost and number of rows. Closely follow design of

[COMMITTERS] pgsql: When we're restricting who can connect, don't allow new

2010-04-26 Thread Robert Haas
Log Message: --- When we're restricting who can connect, don't allow new walsenders. Normal superuser processes are allowed to connect even when the database system is shutting down, or when fewer than superuser_reserved_connection slots remain. This is intended to make sure an

[COMMITTERS] pgsql: Mention related ALTER TABLE variants in documentation for

2010-05-11 Thread Robert Haas
Log Message: --- Mention related ALTER TABLE variants in documentation for CLUSTER. As suggested by Andy Lester. Modified Files: -- pgsql/doc/src/sgml/ref: cluster.sgml (r1.49 - r1.50)

[COMMITTERS] pgsql: Change typedef for rb_appendator to avoid conflict with C++

2010-05-11 Thread Robert Haas
Log Message: --- Change typedef for rb_appendator to avoid conflict with C++ reserved words. Fixes a complaint from src/tools/pginclude/cpluspluscheck reported by Peter Eisentraut. Modified Files: -- pgsql/src/include/utils: rbtree.h (r1.2 - r1.3)

Re: [COMMITTERS] pgsql: Add TODO file to CVS.

2010-05-12 Thread Robert Haas
? Generally I would favor keeping TODOs outside of CVS. One reason is that they tend to have a lot of churn, leading to lots of extra commits to sort through. Another reason is that it makes them harder to update, especially for non-committers. -- Robert Haas EnterpriseDB: http

[COMMITTERS] pgsql: We now accept read-only connections in state

2010-05-14 Thread Robert Haas
Log Message: --- We now accept read-only connections in state PM_RECOVERY_CONSISTENT. Modified Files: -- pgsql/src/backend/postmaster: postmaster.c (r1.606 - r1.607)

[COMMITTERS] pgsql: Rename PM_RECOVERY_CONSISTENT and PMSIGNAL_RECOVERY_CONSISTENT.

2010-05-15 Thread Robert Haas
Log Message: --- Rename PM_RECOVERY_CONSISTENT and PMSIGNAL_RECOVERY_CONSISTENT. The new names PM_HOT_STANDBY and PMSIGNAL_BEGIN_HOT_STANDBY more accurately reflect their actual function. Modified Files: -- pgsql/src/backend/access/transam: xlog.c (r1.412 -

[COMMITTERS] pgsql: Fix longstanding typo in V1 calling conventions documentation.

2010-05-15 Thread Robert Haas
Log Message: --- Fix longstanding typo in V1 calling conventions documentation. Erik Rijkers Modified Files: -- pgsql/doc/src/sgml: xfunc.sgml (r1.146 - r1.147) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/xfunc.sgml?r1=1.146r2=1.147) --

[COMMITTERS] pgsql: Fix longstanding typo in V1 calling conventions documentation.

2010-05-15 Thread Robert Haas
Log Message: --- Fix longstanding typo in V1 calling conventions documentation. Erik Rijkers Tags: REL7_4_STABLE Modified Files: -- pgsql/doc/src/sgml: xfunc.sgml (r1.77.2.1 - r1.77.2.2)

[COMMITTERS] pgsql: Fix longstanding typo in V1 calling conventions documentation.

2010-05-15 Thread Robert Haas
Log Message: --- Fix longstanding typo in V1 calling conventions documentation. Erik Rijkers Tags: REL8_0_STABLE Modified Files: -- pgsql/doc/src/sgml: xfunc.sgml (r1.96.4.3 - r1.96.4.4)

[COMMITTERS] pgsql: Fix longstanding typo in V1 calling conventions documentation.

2010-05-15 Thread Robert Haas
Log Message: --- Fix longstanding typo in V1 calling conventions documentation. Erik Rijkers Tags: REL8_1_STABLE Modified Files: -- pgsql/doc/src/sgml: xfunc.sgml (r1.107.2.1 - r1.107.2.2)

[COMMITTERS] pgsql: Fix longstanding typo in V1 calling conventions documentation.

2010-05-15 Thread Robert Haas
Log Message: --- Fix longstanding typo in V1 calling conventions documentation. Erik Rijkers Tags: REL8_2_STABLE Modified Files: -- pgsql/doc/src/sgml: xfunc.sgml (r1.120.2.2 - r1.120.2.3)

[COMMITTERS] pgsql: Fix longstanding typo in V1 calling conventions documentation.

2010-05-15 Thread Robert Haas
Log Message: --- Fix longstanding typo in V1 calling conventions documentation. Erik Rijkers Tags: REL8_3_STABLE Modified Files: -- pgsql/doc/src/sgml: xfunc.sgml (r1.130.2.1 - r1.130.2.2)

[COMMITTERS] pgsql: Fix longstanding typo in V1 calling conventions documentation.

2010-05-15 Thread Robert Haas
Log Message: --- Fix longstanding typo in V1 calling conventions documentation. Erik Rijkers Tags: REL8_4_STABLE Modified Files: -- pgsql/doc/src/sgml: xfunc.sgml (r1.138.2.1 - r1.138.2.2)

[COMMITTERS] pgsql: Insert line breaks in two places in SQL functions documentation.

2010-05-15 Thread Robert Haas
Log Message: --- Insert line breaks in two places in SQL functions documentation. This avoids a formatting problem in the PDF output. In the HTML output this isn't necessary, but we've done similar things elsewhere in the documentation so I think it's OK to do it here, too. I've

[COMMITTERS] pgsql: Move pg_notify() details to a subsection within the NOTIFY

2010-05-17 Thread Robert Haas
Log Message: --- Move pg_notify() details to a subsection within the NOTIFY reference page. This allows the index to reference the pg_notify() subsection specifically, rather than Notes section of the NOTIFY reference page more generally. Fujii Masao Modified Files: --

[COMMITTERS] pgsql: Unbreak \h; can't do strlen(NULL).

2010-05-21 Thread Robert Haas
Log Message: --- Unbreak \h; can't do strlen(NULL). This was broken by the following commmit. Although the original commit was backpatched all the way to 7.4, this particular bug exists only in the version applied to HEAD.

[COMMITTERS] pgsql: More fixes for shutdown during recovery.

2010-05-26 Thread Robert Haas
this once we've reached normal running, since we must be taking a backup which now won't be valid. But during recovery we must be recovering from a previously taken backup, and any backup label file is needed to restart recovery from the right place. Fujii Masao and Robert Haas Modified Files

[COMMITTERS] pgsql: Fix psql help: \da+ is same as \da, but \daS is not.

2010-05-26 Thread Robert Haas
Log Message: --- Fix psql help: \da+ is same as \da, but \daS is not. Noted by Stephen Frost. Modified Files: -- pgsql/src/bin/psql: help.c (r1.158 - r1.159) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/bin/psql/help.c?r1=1.158r2=1.159) -- Sent

[COMMITTERS] pgsql: Avoid starting walreceiver in states where it shouldn't be

2010-05-26 Thread Robert Haas
Log Message: --- Avoid starting walreceiver in states where it shouldn't be running. In particular, it's bad to start walreceiver when in state PM_WAIT_BACKENDS, because we have no provision to kill walreceiver when in that state. Fujii Masao Modified Files: --

Re: [COMMITTERS] pgsql: tag 7.4.29

2010-05-30 Thread Robert Haas
On Sun, May 30, 2010 at 1:06 PM, Greg Stark gsst...@mit.edu wrote: Uhm. We don't plan to release 7.4 do we? http://wiki.postgresql.org/wiki/PostgreSQL_Release_Support_Policy -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise Postgres Company -- Sent via pgsql-committers

[COMMITTERS] pgsql: On clean shutdown during recovery, don't warn about possible

2010-06-02 Thread Robert Haas
Log Message: --- On clean shutdown during recovery, don't warn about possible corruption. Fujii Masao. Review by Heikki Linnakangas and myself. Modified Files: -- pgsql/src/backend/access/transam: xlog.c (r1.415 - r1.416)

[COMMITTERS] pgsql: Attempt to fix EXPLAIN (FORMAT YAML) quoting to behave sanely.

2010-06-08 Thread Robert Haas
Log Message: --- Attempt to fix EXPLAIN (FORMAT YAML) quoting to behave sanely. The previous code failed to quote in many cases where quoting was necessary - YAML has loads of special characters, including -:[]{},'|* - so quote much more aggressively, and only refrain from quoting things

[COMMITTERS] pgsql: Remove stray word from comment.

2010-06-09 Thread Robert Haas
Log Message: --- Remove stray word from comment. Modified Files: -- pgsql/src/backend/catalog: pg_largeobject.c (r1.39 - r1.40) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/catalog/pg_largeobject.c?r1=1.39r2=1.40) -- Sent via

[COMMITTERS] pgsql: Quote all string values in EXPLAIN (FORMAT YAML) output.

2010-06-09 Thread Robert Haas
Log Message: --- Quote all string values in EXPLAIN (FORMAT YAML) output. While my previous attempt seems to always produce valid YAML, it doesn't always produce YAML that means what it appears to mean, because of tokens like 0xa and true, which without quotes will be interpreted as

[COMMITTERS] pgsql: Fix ALTER LARGE OBJECT and GRANT ...

2010-06-13 Thread Robert Haas
Log Message: --- Fix ALTER LARGE OBJECT and GRANT ... ON LARGE OBJECT for large OIDs. The previous coding failed for OIDs too large to be represented by a signed integer. Modified Files: -- pgsql/src/backend/catalog: aclchk.c (r1.166 - r1.167)

[COMMITTERS] pgsql: Fix typo.

2010-06-13 Thread Robert Haas
Log Message: --- Fix typo. Modified Files: -- pgsql/doc/src/sgml: release-9.0.sgml (r2.29 - r2.30) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/release-9.0.sgml?r1=2.29r2=2.30) -- Sent via pgsql-committers mailing list

[COMMITTERS] pgsql: Fix misplaced modifier.

2010-06-13 Thread Robert Haas
Log Message: --- Fix misplaced modifier. As suggested by Ian Barwick. Modified Files: -- pgsql/doc/src/sgml: release-9.0.sgml (r2.30 - r2.31) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/release-9.0.sgml?r1=2.30r2=2.31) -- Sent via

[COMMITTERS] pgsql: Document new 9.0 behavior of ANALYZE on inheritance hierarchies.

2010-06-15 Thread Robert Haas
Log Message: --- Document new 9.0 behavior of ANALYZE on inheritance hierarchies. In particular, note that autovacuum does not yet understand that it might need to vacuum inheritance parents as a result of changes to the child tables. Modified Files: --

[COMMITTERS] pgsql: Remove hstore's text[] = text[] operator.

2010-06-15 Thread Robert Haas
Log Message: --- Remove hstore's text[] = text[] operator. This is not yet in any released version, so we still have the option to backtrack. Instead, document hstore(text[], text[]). Per discussion. Modified Files: -- pgsql/contrib/hstore: hstore.sql.in (r1.12

[COMMITTERS] pgsql: Document that receive location can rewind if replication

2010-06-16 Thread Robert Haas
Log Message: --- Document that receive location can rewind if replication restarts. Fujii Masao, with some further wordsmithing by me. Modified Files: -- pgsql/doc/src/sgml: func.sgml (r1.518 - r1.519)

[COMMITTERS] pgsql: Rename hstore = text[] operator to % This is not yet in any

2010-06-17 Thread Robert Haas
Log Message: --- Rename hstore = text[] operator to % This is not yet in any released version, so we still have the option to change the name. We may want to reserve the token = in a future release. Modified Files: -- pgsql/contrib/hstore: hstore.sql.in (r1.13 -

[COMMITTERS] pgsql: Minor markup improvements for Hot Standby documentation.

2010-06-21 Thread Robert Haas
Log Message: --- Minor markup improvements for Hot Standby documentation. Modified Files: -- pgsql/doc/src/sgml: config.sgml (r1.281 - r1.282) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/config.sgml?r1=1.281r2=1.282)

[COMMITTERS] pgsql: Updated expected-output file for hstore.

2010-06-22 Thread Robert Haas
Log Message: --- Updated expected-output file for hstore. This is an oversight in my previous patch to deprecate = as an operator name. Per buildfarm. Modified Files: -- pgsql/contrib/hstore/expected: hstore.out (r1.7 - r1.8)

[COMMITTERS] pgsql: Deprecate the use of = as an operator name.

2010-06-22 Thread Robert Haas
Log Message: --- Deprecate the use of = as an operator name. In HEAD, emit a warning when an operator named = is defined. In both HEAD and the backbranches (except in 8.2, where contrib modules do not have documentation), document that hstore's text = text operator may be removed in a

[COMMITTERS] pgsql: Deprecate the use of = as an operator name.

2010-06-22 Thread Robert Haas
Log Message: --- Deprecate the use of = as an operator name. In HEAD, emit a warning when an operator named = is defined. In both HEAD and the backbranches (except in 8.2, where contrib modules do not have documentation), document that hstore's text = text operator may be removed in a

[COMMITTERS] pgsql: Deprecate the use of = as an operator name.

2010-06-22 Thread Robert Haas
Log Message: --- Deprecate the use of = as an operator name. In HEAD, emit a warning when an operator named = is defined. In both HEAD and the backbranches (except in 8.2, where contrib modules do not have documentation), document that hstore's text = text operator may be removed in a

[COMMITTERS] pgsql: Deprecate the use of = as an operator name.

2010-06-22 Thread Robert Haas
Log Message: --- Deprecate the use of = as an operator name. In HEAD, emit a warning when an operator named = is defined. In both HEAD and the backbranches (except in 8.2, where contrib modules do not have documentation), document that hstore's text = text operator may be removed in a

[COMMITTERS] pgsql: Add TCP keepalive support to libpq.

2010-06-23 Thread Robert Haas
Log Message: --- Add TCP keepalive support to libpq. This adds four additional connection parameters to libpq: keepalives, keepalives_idle, keepalives_count, and keepalives_interval. keepalives default to on, per discussion, but can be turned off by specifying keepalives=0. The remaining

[COMMITTERS] pgsql: Add stray else that seems to have gone missing.

2010-06-24 Thread Robert Haas
Log Message: --- Add stray else that seems to have gone missing. Modified Files: -- pgsql/src/backend/postmaster: postmaster.c (r1.612 - r1.613) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/postmaster/postmaster.c?r1=1.612r2=1.613) -- Sent

[COMMITTERS] pgsql: Further 9.0 release notes updates.

2010-06-24 Thread Robert Haas
Log Message: --- Further 9.0 release notes updates. Josh Berkus Modified Files: -- pgsql/doc/src/sgml: release-9.0.sgml (r2.34 - r2.35) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/release-9.0.sgml?r1=2.34r2=2.35) -- Sent via

[COMMITTERS] pgsql: Some copy-editing of the Hot Standby documentation.

2010-06-24 Thread Robert Haas
Log Message: --- Some copy-editing of the Hot Standby documentation. Thanks to Joshua Tolley for the review. Modified Files: -- pgsql/doc/src/sgml: high-availability.sgml (r1.74 - r1.75)

[COMMITTERS] pgsql: Make AIX suggestions about disabling ipv6 more version-sensitive.

2010-06-25 Thread Robert Haas
Log Message: --- Make AIX suggestions about disabling ipv6 more version-sensitive. Chris Browne, based on a report from John Pierce. Modified Files: -- pgsql/doc/src/sgml: installation.sgml (r1.345 - r1.346)

[COMMITTERS] pgsql: Rewrite docs for new libpq keepalive parameters.

2010-06-25 Thread Robert Haas
Log Message: --- Rewrite docs for new libpq keepalive parameters. The revised documentation makes it more clear that these are client-side parameters, rather than server side parameters. It also puts the main point of each parameter first, and consolidates the conditions under which it

[COMMITTERS] pgsql: emode_for_corrupt_record shouldn't reduce LOG messages to

2010-06-28 Thread Robert Haas
Log Message: --- emode_for_corrupt_record shouldn't reduce LOG messages to WARNING. In non-interactive sessions, WARNING sorts below LOG. Modified Files: -- pgsql/src/backend/access/transam: xlog.c (r1.426 - r1.427)

[COMMITTERS] pgsql: Allow ALTER TABLE ..

2010-07-01 Thread Robert Haas
Log Message: --- Allow ALTER TABLE .. SET TABLESPACE to be interrupted. Backpatch to 8.0, where tablespaces were introduced. Guillaume Lelarge Modified Files: -- pgsql/src/backend/commands: tablecmds.c (r1.330 - r1.331)

[COMMITTERS] pgsql: Allow ALTER TABLE ..

2010-07-01 Thread Robert Haas
Log Message: --- Allow ALTER TABLE .. SET TABLESPACE to be interrupted. Backpatch to 8.0, where tablespaces were introduced. Guillaume Lelarge Tags: REL8_0_STABLE Modified Files: -- pgsql/src/backend/commands: tablecmds.c (r1.142.4.11 - r1.142.4.12)

[COMMITTERS] pgsql: Allow ALTER TABLE ..

2010-07-01 Thread Robert Haas
Log Message: --- Allow ALTER TABLE .. SET TABLESPACE to be interrupted. Backpatch to 8.0, where tablespaces were introduced. Guillaume Lelarge Tags: REL8_1_STABLE Modified Files: -- pgsql/src/backend/commands: tablecmds.c (r1.174.2.9 - r1.174.2.10)

[COMMITTERS] pgsql: Allow ALTER TABLE ..

2010-07-01 Thread Robert Haas
Log Message: --- Allow ALTER TABLE .. SET TABLESPACE to be interrupted. Backpatch to 8.0, where tablespaces were introduced. Guillaume Lelarge Tags: REL8_2_STABLE Modified Files: -- pgsql/src/backend/commands: tablecmds.c (r1.206.2.8 - r1.206.2.9)

[COMMITTERS] pgsql: Allow ALTER TABLE ..

2010-07-01 Thread Robert Haas
Log Message: --- Allow ALTER TABLE .. SET TABLESPACE to be interrupted. Backpatch to 8.0, where tablespaces were introduced. Guillaume Lelarge Tags: REL8_4_STABLE Modified Files: -- pgsql/src/backend/commands: tablecmds.c (r1.288.2.3 - r1.288.2.4)

[COMMITTERS] pgsql: Allow copydir() to be interrupted.

2010-07-01 Thread Robert Haas
Log Message: --- Allow copydir() to be interrupted. This makes ALTER DATABASE .. SET TABLESPACE and CREATE DATABASE more sensitive to interrupts. Backpatch to 8.4, where ALTER DATABASE .. SET TABLESPACE was introduced. We could go back further, but in the absence of complaints about the

[COMMITTERS] pgsql: Allow copydir() to be interrupted.

2010-07-01 Thread Robert Haas
Log Message: --- Allow copydir() to be interrupted. This makes ALTER DATABASE .. SET TABLESPACE and CREATE DATABASE more sensitive to interrupts. Backpatch to 8.4, where ALTER DATABASE .. SET TABLESPACE was introduced. We could go back further, but in the absence of complaints about the

Re: [COMMITTERS] pgsql: Allow copydir() to be interrupted.

2010-07-02 Thread Robert Haas
On Fri, Jul 2, 2010 at 8:10 AM, Andrew Dunstan and...@dunslane.net wrote: Robert Haas wrote: Log Message: --- Allow copydir() to be interrupted. This appears to have broken MinGW and Cygwin builds on the buildfarm. Well, that's not awesome. IM-ing with Magnus now. I'm wondering

Re: [COMMITTERS] pgsql: Allow copydir() to be interrupted.

2010-07-02 Thread Robert Haas
On Fri, Jul 2, 2010 at 9:19 AM, Magnus Hagander mag...@hagander.net wrote: On Fri, Jul 2, 2010 at 2:13 PM, Robert Haas robertmh...@gmail.com wrote: On Fri, Jul 2, 2010 at 8:10 AM, Andrew Dunstan and...@dunslane.net wrote: Robert Haas wrote: Log Message: --- Allow copydir

Re: [COMMITTERS] pgsql: Allow copydir() to be interrupted.

2010-07-02 Thread Robert Haas
On Fri, Jul 2, 2010 at 10:18 AM, Tom Lane t...@sss.pgh.pa.us wrote: Robert Haas robertmh...@gmail.com writes: This appears to have broken MinGW and Cygwin builds on the buildfarm. Well, that's not awesome. IM-ing with Magnus now.  I'm wondering if this is a link-ordering problem of some kind

[COMMITTERS] pgsql: Move copydir.c from src/port to src/backend/storage/file The

2010-07-02 Thread Robert Haas
Log Message: --- Move copydir.c from src/port to src/backend/storage/file The previous commit to make copydir() interruptible prevented postgres.exe from linking on MinGW and Cygwin, because on those platforms libpgport_srv.a can't freely reference symbols defined by the backend. Since

[COMMITTERS] pgsql: Move copydir.c from src/port to src/backend/storage/file The

2010-07-02 Thread Robert Haas
Log Message: --- Move copydir.c from src/port to src/backend/storage/file The previous commit to make copydir() interruptible prevented postgres.exe from linking on MinGW and Cygwin, because on those platforms libpgport_srv.a can't freely reference symbols defined by the backend. Since

[COMMITTERS] pgsql: Remove hstore % text[] operator; use slice() function instead.

2010-07-02 Thread Robert Haas
Log Message: --- Remove hstore % text[] operator; use slice() function instead. David Wheeler, with one small correction by me. Modified Files: -- pgsql/contrib/hstore: hstore.sql.in (r1.14 - r1.15)

[COMMITTERS] pgsql: Additional cross-references to window functions documentation.

2010-07-02 Thread Robert Haas
Log Message: --- Additional cross-references to window functions documentation. Erik Rijkers Modified Files: -- pgsql/doc/src/sgml: advanced.sgml (r1.60 - r1.61) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/advanced.sgml?r1=1.60r2=1.61)

[COMMITTERS] pgsql: Allow REASSIGNED OWNED to handle opclasses and opfamilies.

2010-07-03 Thread Robert Haas
Log Message: --- Allow REASSIGNED OWNED to handle opclasses and opfamilies. Backpatch to 8.3, which is as far back as we have opfamilies. The opclass portion could probably be backpatched to 8.2, when REASSIGN OWNED was added, but for now I have not done that. Asko Tiidumaa, with minor

[COMMITTERS] pgsql: Allow REASSIGNED OWNED to handle opclasses and opfamilies.

2010-07-03 Thread Robert Haas
Log Message: --- Allow REASSIGNED OWNED to handle opclasses and opfamilies. Backpatch to 8.3, which is as far back as we have opfamilies. The opclass portion could probably be backpatched to 8.2, when REASSIGN OWNED was added, but for now I have not done that. Asko Tiidumaa, with minor

[COMMITTERS] pgsql: Allow REASSIGNED OWNED to handle opclasses and opfamilies.

2010-07-03 Thread Robert Haas
Log Message: --- Allow REASSIGNED OWNED to handle opclasses and opfamilies. Backpatch to 8.3, which is as far back as we have opfamilies. The opclass portion could probably be backpatched to 8.2, when REASSIGN OWNED was added, but for now I have not done that. Asko Tiidumaa, with minor

[COMMITTERS] pgsql: Support setting the keepalive idle time on MacOS X.

2010-07-06 Thread Robert Haas
Log Message: --- Support setting the keepalive idle time on MacOS X. MacOS X uses TCP_KEEPALIVE rather than TCP_KEEPIDLE for this purpose. Thanks to Fujii Masao for the review. Modified Files: -- pgsql/doc/src/sgml: config.sgml (r1.291 - r1.292)

[COMMITTERS] pgsql: Make log_temp_files based on kB, and revert docs comments to

2010-07-06 Thread Robert Haas
Log Message: --- Make log_temp_files based on kB, and revert docs comments to match. Per extensive discussion on pgsql-hackers. We are deliberately not back-patching this even though the behavior of 8.3 and 8.4 is unquestionably broken, for fear of breaking existing users of this

[COMMITTERS] pgsql: Add a hook in ExecCheckRTPerms().

2010-07-09 Thread Robert Haas
be found in the archives at: http://archives.postgresql.org/pgsql-hackers/2010-05/msg01095.php Robert Haas and Stephen Frost Modified Files: -- pgsql/src/backend/executor: execMain.c (r1.349 - r1.350) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend

[COMMITTERS] pgsql: Clarify that psql -c ignores psqlrc files.

2010-07-09 Thread Robert Haas
Log Message: --- Clarify that psql -c ignores psqlrc files. Tim Landscheidt Modified Files: -- pgsql/doc/src/sgml/ref: psql-ref.sgml (r1.244 - r1.245) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/ref/psql-ref.sgml?r1=1.244r2=1.245) --

[COMMITTERS] pgsql: Clarify that psql -c ignores psqlrc files.

2010-07-09 Thread Robert Haas
Log Message: --- Clarify that psql -c ignores psqlrc files. Tim Landscheidt Tags: REL9_0_STABLE Modified Files: -- pgsql/doc/src/sgml/ref: psql-ref.sgml (r1.244 - r1.244.2.1)

Re: [COMMITTERS] pgsql: Clarify that psql -c ignores psqlrc files.

2010-07-10 Thread Robert Haas
On Jul 10, 2010, at 2:51 AM, David Fetter da...@fetter.org wrote: On Sat, Jul 10, 2010 at 12:50:37AM +, Robert Haas wrote: Log Message: --- Clarify that psql -c ignores psqlrc files. Tim Landscheidt Tags: REL9_0_STABLE Should this be back-patched? To 8.4? We

[COMMITTERS] pgsql: Add restart_after_crash GUC.

2010-07-19 Thread Robert Haas
Log Message: --- Add restart_after_crash GUC. Normally, we automatically restart after a backend crash, but in some cases when PostgreSQL is invoked by clusterware it may be desirable to suppress this behavior, so we provide an option which does this. Since no existing GUC group quite

[COMMITTERS] pgsql: Make hstore regression tests independent of

2010-07-19 Thread Robert Haas
Log Message: --- Make hstore regression tests independent of standard_conforming_strings. Per buildfarm. Modified Files: -- pgsql/contrib/hstore/expected: hstore.out (r1.9 - r1.10)

[COMMITTERS] pgsql: Make ECPG regression tests independent of

2010-07-19 Thread Robert Haas
Log Message: --- Make ECPG regression tests independent of standard_conforming_strings. Per buildfarm, again. Modified Files: -- pgsql/src/interfaces/ecpg/test/expected: sql-quote.c (r1.17 - r1.18)

[COMMITTERS] pgsql: Add \conninfo command to psql, to show current connection info.

2010-07-19 Thread Robert Haas
Log Message: --- Add \conninfo command to psql, to show current connection info. David Christensen. Reviewed by Steve Singer. Some further changes by me. Modified Files: -- pgsql/doc/src/sgml/ref: psql-ref.sgml (r1.245 - r1.246)

[COMMITTERS] pgsql: Have \conninfo mention the port even for local sockets.

2010-07-20 Thread Robert Haas
Log Message: --- Have \conninfo mention the port even for local sockets. Per discussion with David Christensen, there can be multiple instances of PG accessible via local sockets, and you need the port to see which one you're actually connected to. David's original patch worked this way,

[COMMITTERS] pgsql: Centralize DML permissions-checking logic.

2010-07-21 Thread Robert Haas
Log Message: --- Centralize DML permissions-checking logic. Remove bespoke code in DoCopy and RI_Initial_Check, which now instead fabricate call ExecCheckRTPerms with a manufactured RangeTblEntry. This is intended to make it feasible for an enhanced security provider to actually make use

[COMMITTERS] pgsql: Add options to force quoting of all identifiers.

2010-07-21 Thread Robert Haas
Log Message: --- Add options to force quoting of all identifiers. I've added a quote_all_identifiers GUC which affects the behavior of the backend, and a --quote-all-identifiers argument to pg_dump and pg_dumpall which sets the GUC and also affects the quoting done internally by those

[COMMITTERS] pgsql: Fix bogus server version in pg_dumpall --quote-all-identifiers.

2010-07-21 Thread Robert Haas
Log Message: --- Fix bogus server version in pg_dumpall --quote-all-identifiers. Modified Files: -- pgsql/src/bin/pg_dump: pg_dumpall.c (r1.135 - r1.136) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/bin/pg_dump/pg_dumpall.c?r1=1.135r2=1.136) --

[COMMITTERS] pgsql: Add missing function prototype.

2010-07-22 Thread Robert Haas
Log Message: --- Add missing function prototype. Fujii Masao Modified Files: -- pgsql/src/backend/replication: walsender.c (r1.28 - r1.29) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/replication/walsender.c?r1=1.28r2=1.29) -- Sent via

[COMMITTERS] pgsql: Avoid deep recursion when assigning XIDs to multiple levels of

2010-07-22 Thread Robert Haas
Log Message: --- Avoid deep recursion when assigning XIDs to multiple levels of subxacts. Backpatch to 8.0. Andres Freund, with cleanup and adjustment for older branches by me. Modified Files: -- pgsql/src/backend/access/transam: xact.c (r1.293 - r1.294)

[COMMITTERS] pgsql: Avoid deep recursion when assigning XIDs to multiple levels of

2010-07-22 Thread Robert Haas
Log Message: --- Avoid deep recursion when assigning XIDs to multiple levels of subxacts. Backpatch to 8.0. Andres Freund, with cleanup and adjustment for older branches by me. Tags: REL9_0_STABLE Modified Files: -- pgsql/src/backend/access/transam: xact.c

[COMMITTERS] pgsql: Avoid deep recursion when assigning XIDs to multiple levels of

2010-07-22 Thread Robert Haas
Log Message: --- Avoid deep recursion when assigning XIDs to multiple levels of subxacts. Backpatch to 8.0. Andres Freund, with cleanup and adjustment for older branches by me. Tags: REL8_4_STABLE Modified Files: -- pgsql/src/backend/access/transam: xact.c

[COMMITTERS] pgsql: Avoid deep recursion when assigning XIDs to multiple levels of

2010-07-22 Thread Robert Haas
Log Message: --- Avoid deep recursion when assigning XIDs to multiple levels of subxacts. Backpatch to 8.0. Andres Freund, with cleanup and adjustment for older branches by me. Tags: REL8_3_STABLE Modified Files: -- pgsql/src/backend/access/transam: xact.c

[COMMITTERS] pgsql: Avoid deep recursion when assigning XIDs to multiple levels of

2010-07-22 Thread Robert Haas
Log Message: --- Avoid deep recursion when assigning XIDs to multiple levels of subxacts. Backpatch to 8.0. Andres Freund, with cleanup and adjustment for older branches by me. Tags: REL8_2_STABLE Modified Files: -- pgsql/src/backend/access/transam: xact.c

[COMMITTERS] pgsql: Avoid deep recursion when assigning XIDs to multiple levels of

2010-07-22 Thread Robert Haas
Log Message: --- Avoid deep recursion when assigning XIDs to multiple levels of subxacts. Backpatch to 8.0. Andres Freund, with cleanup and adjustment for older branches by me. Tags: REL8_1_STABLE Modified Files: -- pgsql/src/backend/access/transam: xact.c

  1   2   3   4   5   6   7   8   9   10   >