[COMMITTERS] pgsql: Merge the Constraint and FkConstraint node types into a single

2009-07-29 Thread Tom Lane
Log Message: --- Merge the Constraint and FkConstraint node types into a single type. This was foreseen to be a good idea long ago, but nobody had got round to doing it. The recent patch for deferred unique constraints made transformConstraintAttrs() ugly enough that I decided it was time

[COMMITTERS] deny-updates - trunk: Remove errant -'s

2009-07-29 Thread User Decibel
Log Message: --- Remove errant -'s Modified Files: -- trunk/trunk/expected: allow_on_condition_test.out (r1.1 -> r1.2) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/deny-updates/trunk/trunk/expected/allow_on_condition_test.out?r1=1.1&r2=1.2) deny_upd

[COMMITTERS] pgsql: Fix time_part and timetz_part (ie, EXTRACT() for those datatypes)

2009-07-29 Thread Tom Lane
Log Message: --- Fix time_part and timetz_part (ie, EXTRACT() for those datatypes) to include a fractional part in the output for MILLISECOND and SECOND cases, rather than truncating the source value. This is what the float-timestamp code has always done, and it was clearly the code author

[COMMITTERS] pgsql: Fix time_part and timetz_part (ie, EXTRACT() for those datatypes)

2009-07-29 Thread Tom Lane
Log Message: --- Fix time_part and timetz_part (ie, EXTRACT() for those datatypes) to include a fractional part in the output for MILLISECOND and SECOND cases, rather than truncating the source value. This is what the float-timestamp code has always done, and it was clearly the code author

[COMMITTERS] deny-updates - trunk: Switch to using temp table in deny test to make it

2009-07-29 Thread User Decibel
Log Message: --- Switch to using temp table in deny test to make it more portable Modified Files: -- trunk/trunk/expected: deny_updates_test.out (r1.4 -> r1.5) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/deny-updates/trunk/trunk/expected/deny_updates_test.

[COMMITTERS] pgsql: Support deferrable uniqueness constraints.

2009-07-29 Thread Tom Lane
Log Message: --- Support deferrable uniqueness constraints. The current implementation fires an AFTER ROW trigger for each tuple that looks like it might be non-unique according to the index contents at the time of insertion. This works well as long as there aren't many conflicts, but won

[COMMITTERS] pgsql: Fix a thinko introduced into CountActiveBackends by a recent

2009-07-29 Thread Tom Lane
Log Message: --- Fix a thinko introduced into CountActiveBackends by a recent patch: we should ignore NULL array entries, not non-NULL ones. This had the effect of disabling commit_delay, and could have caused a crash in the rare race condition the patch was intended to fix. Bug report an

[COMMITTERS] pgsql: Fix a thinko introduced into CountActiveBackends by a recent

2009-07-29 Thread Tom Lane
Log Message: --- Fix a thinko introduced into CountActiveBackends by a recent patch: we should ignore NULL array entries, not non-NULL ones. This had the effect of disabling commit_delay, and could have caused a crash in the rare race condition the patch was intended to fix. Bug report an

[COMMITTERS] pgsql: Fix a thinko introduced into CountActiveBackends by a recent

2009-07-29 Thread Tom Lane
Log Message: --- Fix a thinko introduced into CountActiveBackends by a recent patch: we should ignore NULL array entries, not non-NULL ones. This had the effect of disabling commit_delay, and could have caused a crash in the rare race condition the patch was intended to fix. Bug report an

[COMMITTERS] pgsql: Fix a thinko introduced into CountActiveBackends by a recent

2009-07-29 Thread Tom Lane
Log Message: --- Fix a thinko introduced into CountActiveBackends by a recent patch: we should ignore NULL array entries, not non-NULL ones. This had the effect of disabling commit_delay, and could have caused a crash in the rare race condition the patch was intended to fix. Bug report an

[COMMITTERS] pgsql: Fix a thinko introduced into CountActiveBackends by a recent

2009-07-29 Thread Tom Lane
Log Message: --- Fix a thinko introduced into CountActiveBackends by a recent patch: we should ignore NULL array entries, not non-NULL ones. This had the effect of disabling commit_delay, and could have caused a crash in the rare race condition the patch was intended to fix. Bug report an