[COMMITTERS] pgsql: Fix typo in solaris spinlock fix.

2014-09-09 Thread Andres Freund
Fix typo in solaris spinlock fix. 07968dbfaad03 missed part of the S_UNLOCK define when building for sparcv8+. Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/50881036b17dc07cc61535d5bf27c56abaa4fbbb Modified Files -- src/include/storage/s_lock.h |1

[COMMITTERS] pgsql: Move ALTER ... ALL IN to ProcessUtilitySlow

2014-09-09 Thread Stephen Frost
Move ALTER ... ALL IN to ProcessUtilitySlow Now that ALTER TABLE .. ALL IN TABLESPACE has replaced the previous ALTER TABLESPACE approach, it makes sense to move the calls down in to ProcessUtilitySlow where the rest of ALTER TABLE is handled. This also means that event triggers will support ALTE

[COMMITTERS] pgsql: Move ALTER ... ALL IN to ProcessUtilitySlow

2014-09-09 Thread Stephen Frost
Move ALTER ... ALL IN to ProcessUtilitySlow Now that ALTER TABLE .. ALL IN TABLESPACE has replaced the previous ALTER TABLESPACE approach, it makes sense to move the calls down in to ProcessUtilitySlow where the rest of ALTER TABLE is handled. This also means that event triggers will support ALTE

[COMMITTERS] pgsql: Allow empty content in xml type

2014-09-09 Thread Peter Eisentraut
Allow empty content in xml type The xml type previously rejected "content" that is empty or consists only of spaces. But the SQL/XML standard allows that, so change that. The accepted values for XML "documents" are not changed. Reviewed-by: Ali Akbar Branch -- master Details --- http:

[COMMITTERS] pgsql: doc: Reflect renaming of Mac OS X to OS X

2014-09-09 Thread Peter Eisentraut
doc: Reflect renaming of Mac OS X to OS X bug #10528 Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/220bb39dee8044937a963e81be8796e99bd8508b Modified Files -- contrib/start-scripts/osx/PostgreSQL |2 +- doc/src/sgml/client-auth.sgml|2 +-

[COMMITTERS] pgsql: doc: Reflect renaming of Mac OS X to OS X

2014-09-09 Thread Peter Eisentraut
doc: Reflect renaming of Mac OS X to OS X bug #10528 Branch -- REL9_4_STABLE Details --- http://git.postgresql.org/pg/commitdiff/18af7938c1efa1ad18c876fcc471020c0ad9db07 Modified Files -- contrib/start-scripts/osx/PostgreSQL |2 +- doc/src/sgml/client-auth.sgml|

[COMMITTERS] pgsql: Add width_bucket(anyelement, anyarray).

2014-09-09 Thread Tom Lane
Add width_bucket(anyelement, anyarray). This provides a convenient method of classifying input values into buckets that are not necessarily equal-width. It works on any sortable data type. The choice of function name is a bit debatable, perhaps, but showing that there's a relationship to the SQL

[COMMITTERS] pgsql: Change the spinlock primitives to function as compiler barriers.

2014-09-09 Thread Robert Haas
Change the spinlock primitives to function as compiler barriers. Previously, they functioned as barriers against CPU reordering but not compiler reordering, an odd API that required extensive use of volatile everywhere that spinlocks are used. That's error-prone and has negative implications for

[COMMITTERS] pgsql: Fix spinlock implementation for some !solaris sparc platforms.

2014-09-09 Thread Andres Freund
Fix spinlock implementation for some !solaris sparc platforms. Some Sparc CPUs can be run in various coherence models, ranging from RMO (relaxed) over PSO (partial) to TSO (total). Solaris has always run CPUs in TSO mode while in userland, but linux didn't use to and the various *BSDs still don't.

[COMMITTERS] pgsql: Fix typo in solaris spinlock fix.

2014-09-09 Thread Andres Freund
Fix typo in solaris spinlock fix. 07968dbfaad03 missed part of the S_UNLOCK define when building for sparcv8+. Branch -- REL9_3_STABLE Details --- http://git.postgresql.org/pg/commitdiff/bca91236a7531fdd6562280156823db2c4f891b8 Modified Files -- src/include/storage/s_lock.h

[COMMITTERS] pgsql: Fix spinlock implementation for some !solaris sparc platforms.

2014-09-09 Thread Andres Freund
Fix spinlock implementation for some !solaris sparc platforms. Some Sparc CPUs can be run in various coherence models, ranging from RMO (relaxed) over PSO (partial) to TSO (total). Solaris has always run CPUs in TSO mode while in userland, but linux didn't use to and the various *BSDs still don't.

[COMMITTERS] pgsql: Fix typo in solaris spinlock fix.

2014-09-09 Thread Andres Freund
Fix typo in solaris spinlock fix. 07968dbfaad03 missed part of the S_UNLOCK define when building for sparcv8+. Branch -- REL9_2_STABLE Details --- http://git.postgresql.org/pg/commitdiff/7679eff0f6bdd840146265082e818bc7ad3e975b Modified Files -- src/include/storage/s_lock.h

[COMMITTERS] pgsql: Fix typo in solaris spinlock fix.

2014-09-09 Thread Andres Freund
Fix typo in solaris spinlock fix. 07968dbfaad03 missed part of the S_UNLOCK define when building for sparcv8+. Branch -- REL9_4_STABLE Details --- http://git.postgresql.org/pg/commitdiff/21dcc48dc7ec48bf7b2a40c619e1c96ca4d2477c Modified Files -- src/include/storage/s_lock.h

[COMMITTERS] pgsql: Fix spinlock implementation for some !solaris sparc platforms.

2014-09-09 Thread Andres Freund
Fix spinlock implementation for some !solaris sparc platforms. Some Sparc CPUs can be run in various coherence models, ranging from RMO (relaxed) over PSO (partial) to TSO (total). Solaris has always run CPUs in TSO mode while in userland, but linux didn't use to and the various *BSDs still don't.

[COMMITTERS] pgsql: Fix spinlock implementation for some !solaris sparc platforms.

2014-09-09 Thread Andres Freund
Fix spinlock implementation for some !solaris sparc platforms. Some Sparc CPUs can be run in various coherence models, ranging from RMO (relaxed) over PSO (partial) to TSO (total). Solaris has always run CPUs in TSO mode while in userland, but linux didn't use to and the various *BSDs still don't.

[COMMITTERS] pgsql: Fix typo in solaris spinlock fix.

2014-09-09 Thread Andres Freund
Fix typo in solaris spinlock fix. 07968dbfaad03 missed part of the S_UNLOCK define when building for sparcv8+. Branch -- REL9_0_STABLE Details --- http://git.postgresql.org/pg/commitdiff/030fd8afc882127c93ac10ce8d187fe46f5d72e2 Modified Files -- src/include/storage/s_lock.h

[COMMITTERS] pgsql: Fix spinlock implementation for some !solaris sparc platforms.

2014-09-09 Thread Andres Freund
Fix spinlock implementation for some !solaris sparc platforms. Some Sparc CPUs can be run in various coherence models, ranging from RMO (relaxed) over PSO (partial) to TSO (total). Solaris has always run CPUs in TSO mode while in userland, but linux didn't use to and the various *BSDs still don't.

[COMMITTERS] pgsql: Fix typo in solaris spinlock fix.

2014-09-09 Thread Andres Freund
Fix typo in solaris spinlock fix. 07968dbfaad03 missed part of the S_UNLOCK define when building for sparcv8+. Branch -- REL9_1_STABLE Details --- http://git.postgresql.org/pg/commitdiff/7288331b9bbb717846f715cefb6712b9521d7b38 Modified Files -- src/include/storage/s_lock.h

[COMMITTERS] pgsql: Add new psql help topics, accessible to both --help and \?.

2014-09-09 Thread Andres Freund
Add new psql help topics, accessible to both --help and \?. Add --help= for the commandline, and \? as a backslash command, to show more help than the invocations without parameters do. "commands", "variables" and "options" currently exist as help topics describing, respectively, backslash comman

[COMMITTERS] pgsql: Preserve AND/OR flatness while extracting restriction OR clauses

2014-09-09 Thread Tom Lane
Preserve AND/OR flatness while extracting restriction OR clauses. The code I added in commit f343a880dfaf1dad0286c5632047c8f599ad was careless about preserving AND/OR flatness: it could create a structure with an OR node directly underneath another one. That breaks an assumption that's fairly

[COMMITTERS] pgsql: Preserve AND/OR flatness while extracting restriction OR clauses

2014-09-09 Thread Tom Lane
Preserve AND/OR flatness while extracting restriction OR clauses. The code I added in commit f343a880dfaf1dad0286c5632047c8f599ad was careless about preserving AND/OR flatness: it could create a structure with an OR node directly underneath another one. That breaks an assumption that's fairly

[COMMITTERS] pgsql: Fix typo in 07c8651dd91d5 causing WIN32_ONLY_COMPILER builds to

2014-09-09 Thread Andres Freund
Fix typo in 07c8651dd91d5 causing WIN32_ONLY_COMPILER builds to fail. Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/b4c28d1b92c81941e4fc124884e51a7c110316bf Modified Files -- src/include/storage/s_lock.h |2 +- 1 file changed, 1 insertion(+), 1 delet

Re: [COMMITTERS] pgsql: Add new psql help topics, accessible to both --help and \?.

2014-09-09 Thread Andres Freund
On 2014-09-09 22:12:35 +, Andres Freund wrote: > Add new psql help topics, accessible to both --help and \?. > > Add --help= for the commandline, and \? as a backslash > command, to show more help than the invocations without parameters > do. "commands", "variables" and "options" currently ex