[COMMITTERS] pgsql: Allow pg_dump to use jobs and serializable transactions together

2015-01-30 Thread Kevin Grittner
Allow pg_dump to use jobs and serializable transactions together. Since 9.3, when the --jobs option was introduced, using it together with the --serializable-deferrable option generated multiple errors. We can get correct behavior by allowing the connection which acquires the snapshot to use SERI

[COMMITTERS] pgsql: Allow pg_dump to use jobs and serializable transactions together

2015-01-30 Thread Kevin Grittner
Allow pg_dump to use jobs and serializable transactions together. Since 9.3, when the --jobs option was introduced, using it together with the --serializable-deferrable option generated multiple errors. We can get correct behavior by allowing the connection which acquires the snapshot to use SERI

[COMMITTERS] pgsql: Allow pg_dump to use jobs and serializable transactions together

2015-01-30 Thread Kevin Grittner
Allow pg_dump to use jobs and serializable transactions together. Since 9.3, when the --jobs option was introduced, using it together with the --serializable-deferrable option generated multiple errors. We can get correct behavior by allowing the connection which acquires the snapshot to use SERI

[COMMITTERS] pgsql: Fix query-duration memory leak with GIN rescans.

2015-01-30 Thread Heikki Linnakangas
Fix query-duration memory leak with GIN rescans. The requiredEntries / additionalEntries arrays were not freed in freeScanKeys() like other per-key stuff. It's not obvious, but startScanKey() was only ever called after the keys have been initialized with ginNewScanKey(). That's why it doesn't nee

[COMMITTERS] pgsql: Fix query-duration memory leak with GIN rescans.

2015-01-30 Thread Heikki Linnakangas
Fix query-duration memory leak with GIN rescans. The requiredEntries / additionalEntries arrays were not freed in freeScanKeys() like other per-key stuff. It's not obvious, but startScanKey() was only ever called after the keys have been initialized with ginNewScanKey(). That's why it doesn't nee

[COMMITTERS] pgsql: Fix assorted oversights in range selectivity estimation.

2015-01-30 Thread Tom Lane
Fix assorted oversights in range selectivity estimation. calc_rangesel() failed outright when comparing range variables to empty constant ranges with < or >=, as a result of missing cases in a switch. It also produced a bogus estimate for > comparison to an empty range. On top of that, the >= and

[COMMITTERS] pgsql: Fix assorted oversights in range selectivity estimation.

2015-01-30 Thread Tom Lane
Fix assorted oversights in range selectivity estimation. calc_rangesel() failed outright when comparing range variables to empty constant ranges with < or >=, as a result of missing cases in a switch. It also produced a bogus estimate for > comparison to an empty range. On top of that, the >= and

[COMMITTERS] pgsql: Fix assorted oversights in range selectivity estimation.

2015-01-30 Thread Tom Lane
Fix assorted oversights in range selectivity estimation. calc_rangesel() failed outright when comparing range variables to empty constant ranges with < or >=, as a result of missing cases in a switch. It also produced a bogus estimate for > comparison to an empty range. On top of that, the >= and

[COMMITTERS] pgsql: Provide a way to supress the "out of memory" error when allocati

2015-01-30 Thread Robert Haas
Provide a way to supress the "out of memory" error when allocating. Using the new interface MemoryContextAllocExtended, callers can specify MCXT_ALLOC_NO_OOM if they are prepared to handle a NULL return value. Michael Paquier, reviewed and somewhat revised by me. Branch -- master Details --

[COMMITTERS] pgsql: Fix Coverity warning about contrib/pgcrypto's mdc_finish().

2015-01-30 Thread Tom Lane
Fix Coverity warning about contrib/pgcrypto's mdc_finish(). Coverity points out that mdc_finish returns a pointer to a local buffer (which of course is gone as soon as the function returns), leaving open a risk of misbehaviors possibly as bad as a stack overwrite. In reality, the only possible ca

[COMMITTERS] pgsql: Fix Coverity warning about contrib/pgcrypto's mdc_finish().

2015-01-30 Thread Tom Lane
Fix Coverity warning about contrib/pgcrypto's mdc_finish(). Coverity points out that mdc_finish returns a pointer to a local buffer (which of course is gone as soon as the function returns), leaving open a risk of misbehaviors possibly as bad as a stack overwrite. In reality, the only possible ca

[COMMITTERS] pgsql: Fix Coverity warning about contrib/pgcrypto's mdc_finish().

2015-01-30 Thread Tom Lane
Fix Coverity warning about contrib/pgcrypto's mdc_finish(). Coverity points out that mdc_finish returns a pointer to a local buffer (which of course is gone as soon as the function returns), leaving open a risk of misbehaviors possibly as bad as a stack overwrite. In reality, the only possible ca

[COMMITTERS] pgsql: Fix Coverity warning about contrib/pgcrypto's mdc_finish().

2015-01-30 Thread Tom Lane
Fix Coverity warning about contrib/pgcrypto's mdc_finish(). Coverity points out that mdc_finish returns a pointer to a local buffer (which of course is gone as soon as the function returns), leaving open a risk of misbehaviors possibly as bad as a stack overwrite. In reality, the only possible ca

[COMMITTERS] pgsql: Fix Coverity warning about contrib/pgcrypto's mdc_finish().

2015-01-30 Thread Tom Lane
Fix Coverity warning about contrib/pgcrypto's mdc_finish(). Coverity points out that mdc_finish returns a pointer to a local buffer (which of course is gone as soon as the function returns), leaving open a risk of misbehaviors possibly as bad as a stack overwrite. In reality, the only possible ca

[COMMITTERS] pgsql: Fix Coverity warning about contrib/pgcrypto's mdc_finish().

2015-01-30 Thread Tom Lane
Fix Coverity warning about contrib/pgcrypto's mdc_finish(). Coverity points out that mdc_finish returns a pointer to a local buffer (which of course is gone as soon as the function returns), leaving open a risk of misbehaviors possibly as bad as a stack overwrite. In reality, the only possible ca

[COMMITTERS] pgsql: doc: Remove superfluous table column

2015-01-30 Thread Peter Eisentraut
doc: Remove superfluous table column Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/e40d43f88eb8617e7c1b3a03dec595efe6066f72 Modified Files -- doc/src/sgml/catalogs.sgml |1 - 1 file changed, 1 deletion(-) -- Sent via pgsql-committers mailing list

[COMMITTERS] pgsql: Fix jsonb Unicode escape processing, and in consequence disallow

2015-01-30 Thread Tom Lane
Fix jsonb Unicode escape processing, and in consequence disallow \u. We've been trying to support \u in JSON values since commit 78ed8e03c67d7333, and have introduced increasingly worse hacks to try to make it work, such as commit 0ad1a816320a2b53. However, it fundamentally can't work in

[COMMITTERS] pgsql: Fix jsonb Unicode escape processing, and in consequence disallow

2015-01-30 Thread Tom Lane
Fix jsonb Unicode escape processing, and in consequence disallow \u. We've been trying to support \u in JSON values since commit 78ed8e03c67d7333, and have introduced increasingly worse hacks to try to make it work, such as commit 0ad1a816320a2b53. However, it fundamentally can't work in

[COMMITTERS] pgsql: Policy documentation improvements

2015-01-30 Thread Stephen Frost
Policy documentation improvements In ALTER POLICY, use 'check_expression' instead of 'expression' for the parameter, to match up with the recent CREATE POLICY change. In CREATE POLICY, frame the discussion as granting access to rows instead of limiting access to rows. Further, clarify that the e

[COMMITTERS] pgsql: Update time zone data files to tzdata release 2015a.

2015-01-30 Thread Tom Lane
Update time zone data files to tzdata release 2015a. DST law changes in Chile and Mexico (state of Quintana Roo). Historical changes for Iceland. Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/08bd0c58115897de8b5c53f616c2add48e8038c2 Modified Files -- s

[COMMITTERS] pgsql: Update time zone data files to tzdata release 2015a.

2015-01-30 Thread Tom Lane
Update time zone data files to tzdata release 2015a. DST law changes in Chile and Mexico (state of Quintana Roo). Historical changes for Iceland. Branch -- REL9_1_STABLE Details --- http://git.postgresql.org/pg/commitdiff/cb24cd3f4a244a0c980fd472f07f33adcc47a43e Modified Files -

[COMMITTERS] pgsql: Update time zone data files to tzdata release 2015a.

2015-01-30 Thread Tom Lane
Update time zone data files to tzdata release 2015a. DST law changes in Chile and Mexico (state of Quintana Roo). Historical changes for Iceland. Branch -- REL9_0_STABLE Details --- http://git.postgresql.org/pg/commitdiff/3553d9c6ee3d97939be039c9f3022936d0fa339f Modified Files -

[COMMITTERS] pgsql: Update time zone data files to tzdata release 2015a.

2015-01-30 Thread Tom Lane
Update time zone data files to tzdata release 2015a. DST law changes in Chile and Mexico (state of Quintana Roo). Historical changes for Iceland. Branch -- REL9_4_STABLE Details --- http://git.postgresql.org/pg/commitdiff/c2b06ab177577d05655ec57239d9a7f2c6e7d9cf Modified Files -

[COMMITTERS] pgsql: Update time zone data files to tzdata release 2015a.

2015-01-30 Thread Tom Lane
Update time zone data files to tzdata release 2015a. DST law changes in Chile and Mexico (state of Quintana Roo). Historical changes for Iceland. Branch -- REL9_3_STABLE Details --- http://git.postgresql.org/pg/commitdiff/8470cd4735470b4acd5b7c4620d28ad6907fd7f6 Modified Files -

[COMMITTERS] pgsql: Update time zone data files to tzdata release 2015a.

2015-01-30 Thread Tom Lane
Update time zone data files to tzdata release 2015a. DST law changes in Chile and Mexico (state of Quintana Roo). Historical changes for Iceland. Branch -- REL9_2_STABLE Details --- http://git.postgresql.org/pg/commitdiff/c9048d353f1361642527d7fe31b6368237ca9079 Modified Files -