[COMMITTERS] pgsql: Use unaligned output in another regression test query to reduce

2014-06-03 Thread Andres Freund
Use unaligned output in another regression test query to reduce diff noise. Use the unaligned/no rowcount output mode in a regression tests that shows all built-in leakproof functions. Currently a new leakproof function will often change the alignment of all existing functions, making it hard to s

[COMMITTERS] pgsql: Set the process latch when processing recovery conflict interrup

2014-06-03 Thread Andres Freund
Set the process latch when processing recovery conflict interrupts. Because RecoveryConflictInterrupt() didn't set the process latch anything using the latter to wait for events didn't get notified about recovery conflicts. Most latch users are never the target of recovery conflicts, which explain

[COMMITTERS] pgsql: Set the process latch when processing recovery conflict interrup

2014-06-03 Thread Andres Freund
Set the process latch when processing recovery conflict interrupts. Because RecoveryConflictInterrupt() didn't set the process latch anything using the latter to wait for events didn't get notified about recovery conflicts. Most latch users are never the target of recovery conflicts, which explain

[COMMITTERS] pgsql: Set the process latch when processing recovery conflict interrup

2014-06-03 Thread Andres Freund
Set the process latch when processing recovery conflict interrupts. Because RecoveryConflictInterrupt() didn't set the process latch anything using the latter to wait for events didn't get notified about recovery conflicts. Most latch users are never the target of recovery conflicts, which explain

[COMMITTERS] pgsql: Set the process latch when processing recovery conflict interrup

2014-06-03 Thread Andres Freund
Set the process latch when processing recovery conflict interrupts. Because RecoveryConflictInterrupt() didn't set the process latch anything using the latter to wait for events didn't get notified about recovery conflicts. Most latch users are never the target of recovery conflicts, which explain

[COMMITTERS] pgsql: Make plpython_unicode regression test work in more database enco

2014-06-03 Thread Tom Lane
Make plpython_unicode regression test work in more database encodings. This test previously used a data value containing U+0080, and would therefore fail if the database encoding didn't have an equivalent to that; which only about half of our supported server encodings do. We could fall back to us

[COMMITTERS] pgsql: Make plpython_unicode regression test work in more database enco

2014-06-03 Thread Tom Lane
Make plpython_unicode regression test work in more database encodings. This test previously used a data value containing U+0080, and would therefore fail if the database encoding didn't have an equivalent to that; which only about half of our supported server encodings do. We could fall back to us

[COMMITTERS] pgsql: Make plpython_unicode regression test work in more database enco

2014-06-03 Thread Tom Lane
Make plpython_unicode regression test work in more database encodings. This test previously used a data value containing U+0080, and would therefore fail if the database encoding didn't have an equivalent to that; which only about half of our supported server encodings do. We could fall back to us

[COMMITTERS] pgsql: Make plpython_unicode regression test work in more database enco

2014-06-03 Thread Tom Lane
Make plpython_unicode regression test work in more database encodings. This test previously used a data value containing U+0080, and would therefore fail if the database encoding didn't have an equivalent to that; which only about half of our supported server encodings do. We could fall back to us

[COMMITTERS] pgsql: Output timestamps in ISO 8601 format when rendering JSON.

2014-06-03 Thread Andrew Dunstan
Output timestamps in ISO 8601 format when rendering JSON. Many JSON processors require timestamp strings in ISO 8601 format in order to convert the strings. When converting a timestamp, with or without timezone, to a JSON datum we therefore now use such a format rather than the type's default text

[COMMITTERS] pgsql: Do not escape a unicode sequence when escaping JSON text.

2014-06-03 Thread Andrew Dunstan
Do not escape a unicode sequence when escaping JSON text. Previously, any backslash in text being escaped for JSON was doubled so that the result was still valid JSON. However, this led to some perverse results in the case of Unicode sequences, These are now detected and the initial backslash is n

[COMMITTERS] pgsql: Use EncodeDateTime instead of to_char to render JSON timestamps.

2014-06-03 Thread Andrew Dunstan
Use EncodeDateTime instead of to_char to render JSON timestamps. Per gripe from Peter Eisentraut and Tom Lane. The output is slightly different, but still ISO 8601 compliant: to_char doesn't output the minutes when time zone offset is an integer number of hours, while EncodeDateTime outputs ":00"

[COMMITTERS] pgsql: Silence Bison deprecation warnings

2014-06-03 Thread Peter Eisentraut
Silence Bison deprecation warnings Bison >=3.0 issues warnings about %name-prefix="base_yy" instead of the now preferred %name-prefix "base_yy" but the latter doesn't work with Bison 2.3 or less. So for now we silence the deprecation warnings. Branch -- master Details --- ht

[COMMITTERS] pgsql: Save pg_stat_statements statistics file into $PGDATA/pg_stat dir

2014-06-03 Thread Fujii Masao
Save pg_stat_statements statistics file into $PGDATA/pg_stat directory at shutdown. 187492b6c2e8cafc5b39063ca3b67846e8155d24 changed pgstat.c so that the stats files were saved into $PGDATA/pg_stat directory when the server was shutdowned. But it accidentally forgot to change the location of pg_s