[COMMITTERS] pgsql: Fix incorrect optimization of foreign-key checks.

2007-07-17 Thread Tom Lane
Log Message: --- Fix incorrect optimization of foreign-key checks. When an UPDATE on the referencing table does not change the tuple's FK column(s), we don't bother to check the PK table since the constraint was presumably already valid. However, the check is still necessary if the tuple w

[COMMITTERS] pgsql: Fix incorrect optimization of foreign-key checks.

2007-07-17 Thread Tom Lane
Log Message: --- Fix incorrect optimization of foreign-key checks. When an UPDATE on the referencing table does not change the tuple's FK column(s), we don't bother to check the PK table since the constraint was presumably already valid. However, the check is still necessary if the tuple w

[COMMITTERS] pgsql: Fix incorrect optimization of foreign-key checks.

2007-07-17 Thread Tom Lane
Log Message: --- Fix incorrect optimization of foreign-key checks. When an UPDATE on the referencing table does not change the tuple's FK column(s), we don't bother to check the PK table since the constraint was presumably already valid. However, the check is still necessary if the tuple w

[COMMITTERS] pgsql: Fix incorrect optimization of foreign-key checks.

2007-07-17 Thread Tom Lane
Log Message: --- Fix incorrect optimization of foreign-key checks. When an UPDATE on the referencing table does not change the tuple's FK column(s), we don't bother to check the PK table since the constraint was presumably already valid. However, the check is still necessary if the tuple w

[COMMITTERS] pgsql: Add: > > o Allow GLOBAL temporary tables to exist as empty by

2007-07-17 Thread Bruce Momjian
Log Message: --- Add: > > o Allow GLOBAL temporary tables to exist as empty by default in > all sessions > > http://archives.postgresql.org/pgsql-hackers/2007-07/msg6.php > Modified Files: -- pgsql/doc: TODO (r1.2206 -> r1.2207)

[COMMITTERS] pgsql: Document that age() adds days, then full months.

2007-07-17 Thread Bruce Momjian
Log Message: --- Document that age() adds days, then full months. Modified Files: -- pgsql/doc/src/sgml: func.sgml (r1.382 -> r1.383) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/func.sgml.diff?r1=1.382&r2=1.383) -

[COMMITTERS] pgsql: Properly adjust age() seconds to match the sign of the larger

2007-07-17 Thread Bruce Momjian
Log Message: --- Properly adjust age() seconds to match the sign of the larger units. Patch from Tom. Modified Files: -- pgsql/src/backend/utils/adt: timestamp.c (r1.179 -> r1.180) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/tim

[COMMITTERS] pgsql: Document that 'deleted' is also tracked by autovacuum.

2007-07-17 Thread Bruce Momjian
Log Message: --- Document that 'deleted' is also tracked by autovacuum. Modified Files: -- pgsql/doc/src/sgml: maintenance.sgml (r1.75 -> r1.76) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/maintenance.sgml.diff?r1=1.75&r2=1.76) -