[COMMITTERS] pgsql: During repeated rescan of GiST index it's possible that scan key

2008-10-17 Thread Teodor Sigaev
Log Message:
---
During repeated rescan of GiST index it's possible that scan key
is NULL but SK_SEARCHNULL is not set. Add checking IS NULL of keys
to set during key initialization. If key is NULL and SK_SEARCHNULL is not
set then nothnig can be satisfied.
With assert-enabled compilation that causes coredump.

Bug was introduced in 8.3 by support of IS NULL index scan.

Modified Files:
--
pgsql/src/backend/access/gist:
gistget.c (r1.75 -> r1.76)

(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/access/gist/gistget.c?r1=1.75&r2=1.76)
gistscan.c (r1.71 -> r1.72)

(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/access/gist/gistscan.c?r1=1.71&r2=1.72)
pgsql/src/include/access:
gist_private.h (r1.32 -> r1.33)

(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/include/access/gist_private.h?r1=1.32&r2=1.33)

-- 
Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-committers


[COMMITTERS] pgsql: During repeated rescan of GiST index it's possible that scan key

2008-10-17 Thread Teodor Sigaev
Log Message:
---
During repeated rescan of GiST index it's possible that scan key
is NULL but SK_SEARCHNULL is not set. Add checking IS NULL of keys
to set during key initialization. If key is NULL and SK_SEARCHNULL is not
set then nothnig can be satisfied.
With assert-enabled compilation that causes coredump.

Bug was introduced in 8.3 by support of IS NULL index scan.

Tags:

REL8_3_STABLE

Modified Files:
--
pgsql/src/backend/access/gist:
gistget.c (r1.69.2.1 -> r1.69.2.2)

(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/access/gist/gistget.c?r1=1.69.2.1&r2=1.69.2.2)
gistscan.c (r1.68.2.1 -> r1.68.2.2)

(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/access/gist/gistscan.c?r1=1.68.2.1&r2=1.68.2.2)
pgsql/src/include/access:
gist_private.h (r1.28.2.1 -> r1.28.2.2)

(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/include/access/gist_private.h?r1=1.28.2.1&r2=1.28.2.2)

-- 
Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-committers


[COMMITTERS] pgsql: Fix small bug in headline generation.

2008-10-17 Thread Teodor Sigaev
Log Message:
---
Fix small bug in headline generation. 
Patch from Sushant Sinha <[EMAIL PROTECTED]> 
http://archives.postgresql.org/pgsql-hackers/2008-07/msg00785.php

Modified Files:
--
pgsql/src/backend/tsearch:
wparser_def.c (r1.15 -> r1.16)

(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/tsearch/wparser_def.c?r1=1.15&r2=1.16)

-- 
Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-committers


[COMMITTERS] pgsql: Fix small bug in headline generation.

2008-10-17 Thread Teodor Sigaev
Log Message:
---
Fix small bug in headline generation. 
Patch from Sushant Sinha <[EMAIL PROTECTED]> 
http://archives.postgresql.org/pgsql-hackers/2008-07/msg00785.php

Tags:

REL8_3_STABLE

Modified Files:
--
pgsql/src/backend/tsearch:
wparser_def.c (r1.14 -> r1.14.2.1)

(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/tsearch/wparser_def.c?r1=1.14&r2=1.14.2.1)

-- 
Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-committers


[COMMITTERS] pgsql: Fix small bug in headline generation.

2008-10-17 Thread Teodor Sigaev
Log Message:
---
Fix small bug in headline generation. 
Patch from Sushant Sinha <[EMAIL PROTECTED]> 
http://archives.postgresql.org/pgsql-hackers/2008-07/msg00785.php

Tags:

REL8_2_STABLE

Modified Files:
--
pgsql/contrib/tsearch2:
wparser_def.c (r1.15 -> r1.15.2.1)

(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/contrib/tsearch2/wparser_def.c?r1=1.15&r2=1.15.2.1)

-- 
Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-committers


[COMMITTERS] pgsql: Fix small bug in headline generation.

2008-10-17 Thread Teodor Sigaev
Log Message:
---
Fix small bug in headline generation. 
Patch from Sushant Sinha <[EMAIL PROTECTED]> 
http://archives.postgresql.org/pgsql-hackers/2008-07/msg00785.php

Tags:

REL8_1_STABLE

Modified Files:
--
pgsql/contrib/tsearch2:
wparser_def.c (r1.13 -> r1.13.2.1)

(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/contrib/tsearch2/wparser_def.c?r1=1.13&r2=1.13.2.1)

-- 
Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-committers


[COMMITTERS] pgsql: Fix small bug in headline generation.

2008-10-17 Thread Teodor Sigaev
Log Message:
---
Fix small bug in headline generation. 
Patch from Sushant Sinha <[EMAIL PROTECTED]> 
http://archives.postgresql.org/pgsql-hackers/2008-07/msg00785.php

Tags:

REL8_0_STABLE

Modified Files:
--
pgsql/contrib/tsearch2:
wparser_def.c (r1.11.4.1 -> r1.11.4.2)

(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/contrib/tsearch2/wparser_def.c?r1=1.11.4.1&r2=1.11.4.2)

-- 
Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-committers


[COMMITTERS] pgsql: Fix small bug in headline generation.

2008-10-17 Thread Teodor Sigaev
Log Message:
---
Fix small bug in headline generation. 
Patch from Sushant Sinha <[EMAIL PROTECTED]> 
http://archives.postgresql.org/pgsql-hackers/2008-07/msg00785.php

Tags:

REL7_4_STABLE

Modified Files:
--
pgsql/contrib/tsearch2:
wparser_def.c (r1.5.4.1 -> r1.5.4.2)

(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/contrib/tsearch2/wparser_def.c?r1=1.5.4.1&r2=1.5.4.2)

-- 
Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-committers


[COMMITTERS] pgsql: Improve headeline generation.

2008-10-17 Thread Teodor Sigaev
Log Message:
---
Improve headeline generation. Now headline can contain 
several fragments a-la Google.

Sushant Sinha <[EMAIL PROTECTED]>

Modified Files:
--
pgsql/doc/src/sgml:
textsearch.sgml (r1.45 -> r1.46)

(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/textsearch.sgml?r1=1.45&r2=1.46)
pgsql/src/backend/tsearch:
ts_parse.c (r1.8 -> r1.9)

(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/tsearch/ts_parse.c?r1=1.8&r2=1.9)
wparser_def.c (r1.16 -> r1.17)

(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/tsearch/wparser_def.c?r1=1.16&r2=1.17)
pgsql/src/include/tsearch:
ts_public.h (r1.10 -> r1.11)

(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/include/tsearch/ts_public.h?r1=1.10&r2=1.11)
pgsql/src/test/regress/expected:
tsearch.out (r1.14 -> r1.15)

(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/expected/tsearch.out?r1=1.14&r2=1.15)
pgsql/src/test/regress/sql:
tsearch.sql (r1.9 -> r1.10)

(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/sql/tsearch.sql?r1=1.9&r2=1.10)

-- 
Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-committers


[COMMITTERS] pgsql: Improve comments about RelOptInfo.reltargetlist.

2008-10-17 Thread Tom Lane
Log Message:
---
Improve comments about RelOptInfo.reltargetlist.

Modified Files:
--
pgsql/src/include/nodes:
relation.h (r1.160 -> r1.161)

(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/include/nodes/relation.h?r1=1.160&r2=1.161)

-- 
Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-committers


[COMMITTERS] pgsql: Salvage a little bit of work from a failed patch: simplify and

2008-10-17 Thread Tom Lane
Log Message:
---
Salvage a little bit of work from a failed patch: simplify and speed up
set_rel_width().  The code had been catering for the possibility of different
varnos in the relation targetlist, but this is impossible for a base relation
(and if it were possible, putting all the widths in the same RelOptInfo would
be wrong anyway).

Modified Files:
--
pgsql/src/backend/optimizer/path:
costsize.c (r1.198 -> r1.199)

(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/optimizer/path/costsize.c?r1=1.198&r2=1.199)

-- 
Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-committers


[COMMITTERS] pgsql: Add a new column to pg_am to specify whether an index AM supports

2008-10-17 Thread Tom Lane
Log Message:
---
Add a new column to pg_am to specify whether an index AM supports backward
scanning; GiST and GIN do not, and it seems like too much trouble to make
them do so.  By teaching ExecSupportsBackwardScan() about this restriction,
we ensure that the planner will protect a scroll cursor from the problem
by adding a Materialize node.

In passing, fix another longstanding bug in the same area: backwards scan of
a plan with set-returning functions in the targetlist did not work either,
since the TupFromTlist expansion code pays no attention to direction (and
has no way to run a SRF backwards anyway).  Again the fix is to make
ExecSupportsBackwardScan check this restriction.

Also adjust the index AM API specification to note that mark/restore support
is unnecessary if the AM can't produce ordered output.

Modified Files:
--
pgsql/doc/src/sgml:
catalogs.sgml (r2.178 -> r2.179)

(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/catalogs.sgml?r1=2.178&r2=2.179)
indexam.sgml (r2.27 -> r2.28)

(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/indexam.sgml?r1=2.27&r2=2.28)
pgsql/src/backend/executor:
execAmi.c (r1.99 -> r1.100)

(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/executor/execAmi.c?r1=1.99&r2=1.100)
pgsql/src/include/catalog:
catversion.h (r1.498 -> r1.499)

(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/include/catalog/catversion.h?r1=1.498&r2=1.499)
pg_am.h (r1.58 -> r1.59)

(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/include/catalog/pg_am.h?r1=1.58&r2=1.59)

-- 
Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-committers


[COMMITTERS] pgsql: Refactor some duplicate code to set up formatted_log_time and

2008-10-17 Thread Alvaro Herrera
Log Message:
---
Refactor some duplicate code to set up formatted_log_time and
formatted_start_time.

Modified Files:
--
pgsql/src/backend/utils/error:
elog.c (r1.207 -> r1.208)

(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/error/elog.c?r1=1.207&r2=1.208)

-- 
Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-committers


[COMMITTERS] pgsql: Small correction SQL feature table

2008-10-17 Thread Peter Eisentraut
Log Message:
---
Small correction SQL feature table

Tags:

REL8_3_STABLE

Modified Files:
--
pgsql/src/backend/catalog:
sql_features.txt (r1.16 -> r1.16.2.1)

(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/catalog/sql_features.txt?r1=1.16&r2=1.16.2.1)

-- 
Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-committers


[COMMITTERS] pgsql: Remove useless mark/restore support in hash index AM, per

2008-10-17 Thread Tom Lane
Log Message:
---
Remove useless mark/restore support in hash index AM, per discussion.
(I'm leaving GiST/GIN cleanup to Teodor.)

Modified Files:
--
pgsql/src/backend/access/hash:
hash.c (r1.105 -> r1.106)

(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/access/hash/hash.c?r1=1.105&r2=1.106)
pgsql/src/include/access:
hash.h (r1.90 -> r1.91)

(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/include/access/hash.h?r1=1.90&r2=1.91)

-- 
Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-committers


[COMMITTERS] pgsql: Update feature list for SQL:2008.

2008-10-17 Thread Peter Eisentraut
Log Message:
---
Update feature list for SQL:2008.

Modified Files:
--
pgsql/doc/src/sgml:
features.sgml (r2.27 -> r2.28)

(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/features.sgml?r1=2.27&r2=2.28)
mk_feature_tables.pl (r2.2 -> r2.3)

(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/mk_feature_tables.pl?r1=2.2&r2=2.3)
pgsql/src/backend/catalog:
sql_features.txt (r1.16 -> r1.17)

(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/catalog/sql_features.txt?r1=1.16&r2=1.17)

-- 
Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-committers


[COMMITTERS] pgsql: Fix broken SQL features data, per buildfarm results.

2008-10-17 Thread Tom Lane
Log Message:
---
Fix broken SQL features data, per buildfarm results.

Modified Files:
--
pgsql/src/backend/catalog:
sql_features.txt (r1.17 -> r1.18)

(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/catalog/sql_features.txt?r1=1.17&r2=1.18)

-- 
Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-committers