[COMMITTERS] pgsql: Do a pass of code review for the ALTER TABLE ADD INHERITS patch.

2006-07-01 Thread Neil Conway
Log Message: --- Do a pass of code review for the ALTER TABLE ADD INHERITS patch. Keep the read lock we hold on the table's parent relation until commit. Update equalfuncs.c for the new field in AlterTableCmd. Various improvements to comments, variable names, and error reporting. There is

[COMMITTERS] pgsql: Add FILLFACTOR to CREATE INDEX.

2006-07-01 Thread Bruce Momjian
Log Message: --- Add FILLFACTOR to CREATE INDEX. ITAGAKI Takahiro Modified Files: -- pgsql/doc/src/sgml/ref: alter_index.sgml (r1.8 -> r1.9) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/ref/alter_index.sgml.diff?r1=1.8&r2=1.9) alt

[COMMITTERS] pgsql: Done: > * -Add fillfactor to control reserved free space during

2006-07-01 Thread Bruce Momjian
Log Message: --- Done: > * -Add fillfactor to control reserved free space during index creation Modified Files: -- pgsql/doc: TODO (r1.1911 -> r1.1912) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/TODO.diff?r1=1.1911&r2=1.1912) pgsql/doc/src/F

[COMMITTERS] pgsql: Done: < o Add ALTER TABLE tab ADD/DROP INHERITS parent <

2006-07-01 Thread Bruce Momjian
Log Message: --- Done: < o Add ALTER TABLE tab ADD/DROP INHERITS parent < < This allows tables to be added/removed from an inheritance < hierarchy. This is particularly useful for table partitioning. < http://archives.postgresql.org/pgsql-hackers/2006-05/msg

[COMMITTERS] pgsql: ALTER TABLE ...

2006-07-01 Thread Bruce Momjian
Log Message: --- ALTER TABLE ... ADD/DROPS INHERIT (actually INHERIT / NO INHERIT) Open items: There were a few tangentially related issues that have come up that I think are TODOs. I'm likely to tackle one or two of these next so I'm interested in hearing feedback on them as well. . Con

[COMMITTERS] pgsql: Fix oversight in planning for multiple indexscans driven by

2006-07-01 Thread Tom Lane
Log Message: --- Fix oversight in planning for multiple indexscans driven by ScalarArrayOpExpr index quals: we were estimating the right total number of rows returned, but treating the index-access part of the cost as if a single scan were fetching that many consecutive index tuples. Actua

[COMMITTERS] pgsql: Revise the planner's handling of "pseudoconstant" WHERE clauses,

2006-07-01 Thread Tom Lane
Log Message: --- Revise the planner's handling of "pseudoconstant" WHERE clauses, that is clauses containing no variables and no volatile functions. Such a clause can be used as a one-time qual in a gating Result plan node, to suppress plan execution entirely when it is false. Even when t

[COMMITTERS] pgfouine - pgfouine: preparing 0.6.1 release

2006-07-01 Thread User Gsmet
Log Message: --- preparing 0.6.1 release Modified Files: -- pgfouine: pgfouine.spec (r1.8 -> r1.9) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgfouine/pgfouine/pgfouine.spec.diff?r1=1.8&r2=1.9) pgfouine.php (r1.44 -> r1.45) (http://cvs.pg