[COMMITTERS] pgsql: Collect and use histograms of lower and upper bounds for range t

2012-08-27 Thread Heikki Linnakangas
Collect and use histograms of lower and upper bounds for range types. This enables selectivity estimation of the <<, >>, &<, &> and && operators, as well as the normal inequality operators: <, <=, >=, >. "range @> element" is also supported, but the range-variant @> and <@ operators are not, becau

[COMMITTERS] pgsql: Have pgindent requre pg_bsd_indent version 1.2 now that a new ve

2012-08-27 Thread Bruce Momjian
Have pgindent requre pg_bsd_indent version 1.2 now that a new version has been created by adding #include to parse.c. per request from Kevin Grittner. Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/e40bddb0f3ce9f9bf7c960b35f6ac0c19f65612b Modified Files --

[COMMITTERS] pgsql: Fix DROP INDEX CONCURRENTLY IF EXISTS.

2012-08-27 Thread Tom Lane
Fix DROP INDEX CONCURRENTLY IF EXISTS. This threw ERROR, not the expected NOTICE, if the index didn't exist. The bug was actually visible in not-as-expected regression test output, so somebody wasn't paying too close attention in commit 8cb53654dbdb4c386369eb988062d0bbb6de725e. Per report from Bre

[COMMITTERS] pgsql: Fix DROP INDEX CONCURRENTLY IF EXISTS.

2012-08-27 Thread Tom Lane
Fix DROP INDEX CONCURRENTLY IF EXISTS. This threw ERROR, not the expected NOTICE, if the index didn't exist. The bug was actually visible in not-as-expected regression test output, so somebody wasn't paying too close attention in commit 8cb53654dbdb4c386369eb988062d0bbb6de725e. Per report from Bre

[COMMITTERS] pgsql: Fix thinko in comment

2012-08-27 Thread Alvaro Herrera
Fix thinko in comment It was confusing symlinks with hard links. Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/34c02044ed7e7defde5a853b26dcd806c872d974 Modified Files -- contrib/pg_upgrade/file.c |4 ++-- 1 files changed, 2 insertions(+), 2 deletion

[COMMITTERS] pgsql: Remove analyze_new_cluster.sh on make clean, too

2012-08-27 Thread Alvaro Herrera
Remove analyze_new_cluster.sh on make clean, too Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/ab577e63faf792593ca728625a8ef0b1dfaf7500 Modified Files -- contrib/pg_upgrade/Makefile |2 +- 1 files changed, 1 insertions(+), 1 deletions(-) -- Sent v

[COMMITTERS] pgsql: pg_upgrade: Fix exec_prog API to be less flaky

2012-08-27 Thread Alvaro Herrera
pg_upgrade: Fix exec_prog API to be less flaky The previous signature made it very easy to pass something other than the printf-format specifier in the corresponding position, without any warning from the compiler. While at it, move some of the escaping, redirecting and quoting responsibilities f

[COMMITTERS] pgsql: Back-patch fixes for some issues in our Windows socket code into

2012-08-27 Thread Robert Haas
Back-patch fixes for some issues in our Windows socket code into 9.1. This is a backport of commit b85427f2276d02756b558c0024949305ea65aca5. Per discussion of bug #4958. Some of these fixes probably need to be back-patched further, but I'm just doing this much for now. Branch -- REL9_1_STABL

[COMMITTERS] pgsql: Document the lack of reading the PGDATABASE environment variable

2012-08-27 Thread Bruce Momjian
Document the lack of reading the PGDATABASE environment variable in pg_restore. Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/483c2c1071c45e275782d33d646c3018f02f9f94 Modified Files -- doc/src/sgml/ref/pg_restore.sgml |3 ++- 1 files changed, 2 inser

[COMMITTERS] pgsql: Add section IDs to subsections of syntax.sgml that lacked them.

2012-08-27 Thread Tom Lane
Add section IDs to subsections of syntax.sgml that lacked them. This is so that these sections will have stable HTML tags that one can link to, rather than things like "AEN1902". Perhaps we should mount a campaign to do this everywhere, but I've found myself pointing at syntax.sgml subsections of

[COMMITTERS] pgsql: Add section IDs to subsections of syntax.sgml that lacked them.

2012-08-27 Thread Tom Lane
Add section IDs to subsections of syntax.sgml that lacked them. This is so that these sections will have stable HTML tags that one can link to, rather than things like "AEN1902". Perhaps we should mount a campaign to do this everywhere, but I've found myself pointing at syntax.sgml subsections of

[COMMITTERS] pgsql: Improve a couple of 9.2 release note entries.

2012-08-27 Thread Tom Lane
Improve a couple of 9.2 release note entries. Clarify the compatibility notes about EXTRACT() and about statistics timing columns. Branch -- REL9_2_STABLE Details --- http://git.postgresql.org/pg/commitdiff/a63b7744fa4abdabc977dd4525d0444ddf10f9ed Modified Files -- doc/src/s

[COMMITTERS] pgsql: Improve a couple of 9.2 release note entries.

2012-08-27 Thread Tom Lane
Improve a couple of 9.2 release note entries. Clarify the compatibility notes about EXTRACT() and about statistics timing columns. Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/7417a8e3dd14886887447053a5ccbd4f9501ba61 Modified Files -- doc/src/sgml/rel

Re: [COMMITTERS] pgsql: Don't install hstore--1.0.sql any more.

2012-08-27 Thread Bruce Momjian
On Sun, Feb 26, 2012 at 05:26:03PM -0500, Tom Lane wrote: > Robert Haas writes: > > On Thu, Feb 23, 2012 at 11:25 AM, Tom Lane wrote: > >> Shouldn't this commit have removed the 1.0 file from git altogether? > >> It's quite useless if it's not going to get installed. > > > I left it for the poss

[COMMITTERS] pgsql: Document how to create advisory lock "bigint" values in SQL.

2012-08-27 Thread Bruce Momjian
Document how to create advisory lock "bigint" values in SQL. David E. Wheeler Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/bf849af7f347ebcd394d6d789f557e75ead2f5ee Modified Files -- doc/src/sgml/catalogs.sgml |5 - 1 files changed, 4 insertions