[COMMITTERS] pgsql: Emit cascaded standby message on shutdown only when appropriate.

2011-09-07 Thread Simon Riggs
Emit cascaded standby message on shutdown only when appropriate. Adds additional test for active walsenders and closes a race condition for when we failover when a new walsender was connecting. Reported and fixed bu Fujii Masao. Review by Heikki Linnakangas Branch -- master Details --- h

[COMMITTERS] pgsql: Partially revoke attempt to improve performance with many savepo

2011-09-07 Thread Simon Riggs
Partially revoke attempt to improve performance with many savepoints. Maintain difference between subtransaction release and commit introduced by earlier patch. Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/df383b03e6f761c9b5bb12aa2339795ab44aa054 Modified Files --

[COMMITTERS] pgsql: Revert documentation patch about NEW/OLD and triggers.

2011-09-07 Thread Bruce Momjian
Revert documentation patch about NEW/OLD and triggers. Backpatch to 9.0 and 9.1. Patch from Josh Kupershmidt. Branch -- REL9_0_STABLE Details --- http://git.postgresql.org/pg/commitdiff/336059fc0af59f60d1e4c4a1f28a06f97a0e30a9 Modified Files -- doc/src/sgml/plpgsql.sgml |

[COMMITTERS] pgsql: Revert documentation patch about NEW/OLD and triggers.

2011-09-07 Thread Bruce Momjian
Revert documentation patch about NEW/OLD and triggers. Backpatch to 9.0 and 9.1. Patch from Josh Kupershmidt. Branch -- REL9_1_STABLE Details --- http://git.postgresql.org/pg/commitdiff/d5d94e16011a4fbb52de13a3d1ca326ad0c4ff36 Modified Files -- doc/src/sgml/plpgsql.sgml |

[COMMITTERS] pgsql: Revert documentation patch about NEW/OLD and triggers.

2011-09-07 Thread Bruce Momjian
Revert documentation patch about NEW/OLD and triggers. Backpatch to 9.0 and 9.1. Patch from Josh Kupershmidt. Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/8eacb25cbe9100b9cf441d4cbca4cec8fa5e3f52 Modified Files -- doc/src/sgml/plpgsql.sgml |8 +++

[COMMITTERS] pgsql: Fix to_date() and to_timestamp() to handle year masks of length

2011-09-07 Thread Bruce Momjian
Fix to_date() and to_timestamp() to handle year masks of length < 4 so they wrap toward year 2020, rather than the inconsistent behavior we had before. Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/029dfdf1157b6d837a7b7211cd35b00c6bcd767c Modified Files ---

[COMMITTERS] pgsql: Fix bug introduced by pgrminclude where the tablespace version n

2011-09-07 Thread Bruce Momjian
Fix bug introduced by pgrminclude where the tablespace version name was not expanded. Bump catalog version number to force initdb for all tablespaces. Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/f81fb4f690355bc88fee69624103956fb4576fe5 Modified Files ---

[COMMITTERS] pgsql: Have pgrminclude skip files that use CppAsString2 because CppAsS

2011-09-07 Thread Bruce Momjian
Have pgrminclude skip files that use CppAsString2 because CppAsString2 will expaned undefined identifiers. Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/f19593754a1b9293b098975fc43263125a40a4c3 Modified Files -- src/tools/pginclude/pgrminclude |2 ++

[COMMITTERS] pgsql: Fix get_name_for_var_field() to deal with RECORD Params.

2011-09-07 Thread Tom Lane
Fix get_name_for_var_field() to deal with RECORD Params. With 9.1's use of Params to pass down values from NestLoop join nodes to their inner plans, it is possible for a Param to have type RECORD, in which case the set of fields comprising the value isn't determinable by inspection of the Param al

[COMMITTERS] pgsql: Fix get_name_for_var_field() to deal with RECORD Params.

2011-09-07 Thread Tom Lane
Fix get_name_for_var_field() to deal with RECORD Params. With 9.1's use of Params to pass down values from NestLoop join nodes to their inner plans, it is possible for a Param to have type RECORD, in which case the set of fields comprising the value isn't determinable by inspection of the Param al

[COMMITTERS] pgsql: Fix typo in error message.

2011-09-07 Thread Tom Lane
Fix typo in error message. Per Euler Taveira de Oliveira. Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/99155aaa33f417daabd38c8b225c09a3c6da71ba Modified Files -- src/backend/commands/collationcmds.c |2 +- 1 files changed, 1 insertions(+), 1 deleti

[COMMITTERS] pgsql: Fix typo in error message.

2011-09-07 Thread Tom Lane
Fix typo in error message. Per Euler Taveira de Oliveira. Branch -- REL9_1_STABLE Details --- http://git.postgresql.org/pg/commitdiff/673dfe9690a54889bdb434321552f227806209fa Modified Files -- src/backend/commands/collationcmds.c |2 +- 1 files changed, 1 insertions(+), 1

[COMMITTERS] pgsql: In pg_upgrade, disallow migration of 8.3 clusters using contrib/

2011-09-07 Thread Bruce Momjian
In pg_upgrade, disallow migration of 8.3 clusters using contrib/ltree because its internal format was changed in 8.4. Backpatch to 9.0 and 9.1. Report by depesz, diagnosis by Tom. Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/3ced32d24e14af1877171c085a635b4ccdf893

[COMMITTERS] pgsql: In pg_upgrade, disallow migration of 8.3 clusters using contrib/

2011-09-07 Thread Bruce Momjian
In pg_upgrade, disallow migration of 8.3 clusters using contrib/ltree because its internal format was changed in 8.4. Backpatch to 9.0 and 9.1. Report by depesz, diagnosis by Tom. Branch -- REL9_1_STABLE Details --- http://git.postgresql.org/pg/commitdiff/8cdd62068d2b6913902741f2fbc74d5

[COMMITTERS] pgsql: In pg_upgrade, disallow migration of 8.3 clusters using contrib/

2011-09-07 Thread Bruce Momjian
In pg_upgrade, disallow migration of 8.3 clusters using contrib/ltree because its internal format was changed in 8.4. Backpatch to 9.0 and 9.1. Report by depesz, diagnosis by Tom. Branch -- REL9_0_STABLE Details --- http://git.postgresql.org/pg/commitdiff/c3106a340f3177105b80a0a6e878eba

[COMMITTERS] pgsql: Allow bcc32 and win32 batch files to compile libpq.

2011-09-07 Thread Bruce Momjian
Allow bcc32 and win32 batch files to compile libpq. Backpatch to 9.1. By Hiroshi Saito Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/7b8e10f2bed1d450a9f9b211ae1b883227443912 Modified Files -- src/interfaces/libpq/bcc32.mak | 14 ++ src/in

[COMMITTERS] pgsql: Allow bcc32 and win32 batch files to compile libpq.

2011-09-07 Thread Bruce Momjian
Allow bcc32 and win32 batch files to compile libpq. Backpatch to 9.1. By Hiroshi Saito Branch -- REL9_1_STABLE Details --- http://git.postgresql.org/pg/commitdiff/60765d86c3a91bf2fdf796ee66672120fd599d02 Modified Files -- src/interfaces/libpq/bcc32.mak | 14 ++

[COMMITTERS] pgsql: Fix corner case bug in numeric to_char().

2011-09-07 Thread Tom Lane
Fix corner case bug in numeric to_char(). Trailing-zero stripping applied by the FM specifier could strip zeroes to the left of the decimal point, for a format with no digit positions after the decimal point (such as "FM999."). Reported and diagnosed by Marti Raudsepp, though I didn't use his pat

[COMMITTERS] pgsql: Fix corner case bug in numeric to_char().

2011-09-07 Thread Tom Lane
Fix corner case bug in numeric to_char(). Trailing-zero stripping applied by the FM specifier could strip zeroes to the left of the decimal point, for a format with no digit positions after the decimal point (such as "FM999."). Reported and diagnosed by Marti Raudsepp, though I didn't use his pat

[COMMITTERS] pgsql: Fix corner case bug in numeric to_char().

2011-09-07 Thread Tom Lane
Fix corner case bug in numeric to_char(). Trailing-zero stripping applied by the FM specifier could strip zeroes to the left of the decimal point, for a format with no digit positions after the decimal point (such as "FM999."). Reported and diagnosed by Marti Raudsepp, though I didn't use his pat

[COMMITTERS] pgsql: Fix corner case bug in numeric to_char().

2011-09-07 Thread Tom Lane
Fix corner case bug in numeric to_char(). Trailing-zero stripping applied by the FM specifier could strip zeroes to the left of the decimal point, for a format with no digit positions after the decimal point (such as "FM999."). Reported and diagnosed by Marti Raudsepp, though I didn't use his pat

[COMMITTERS] pgsql: Fix corner case bug in numeric to_char().

2011-09-07 Thread Tom Lane
Fix corner case bug in numeric to_char(). Trailing-zero stripping applied by the FM specifier could strip zeroes to the left of the decimal point, for a format with no digit positions after the decimal point (such as "FM999."). Reported and diagnosed by Marti Raudsepp, though I didn't use his pat

[COMMITTERS] pgsql: Fix corner case bug in numeric to_char().

2011-09-07 Thread Tom Lane
Fix corner case bug in numeric to_char(). Trailing-zero stripping applied by the FM specifier could strip zeroes to the left of the decimal point, for a format with no digit positions after the decimal point (such as "FM999."). Reported and diagnosed by Marti Raudsepp, though I didn't use his pat

[COMMITTERS] pgsql: One last round of copy-editing for the 9.1 release notes.

2011-09-07 Thread Tom Lane
One last round of copy-editing for the 9.1 release notes. Also set the documented release date to 2011-09-12. Branch -- REL9_1_STABLE Details --- http://git.postgresql.org/pg/commitdiff/c7d60312fb661cdb212c63924249d623bd9d87c6 Modified Files -- doc/src/sgml/release-9.1.sgml

[COMMITTERS] pgsql: One last round of copy-editing for the 9.1 release notes.

2011-09-07 Thread Tom Lane
One last round of copy-editing for the 9.1 release notes. Also set the documented release date to 2011-09-12. Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/09b68c70af855a0a69cede14da70968ddd97ba05 Modified Files -- doc/src/sgml/release-9.1.sgml | 81