Re: [BUGS] BUG #5988: CTINE duplicates constraints

2011-04-25 Thread Robert Haas
On Mon, Apr 25, 2011 at 11:06 AM, Tom Lane wrote: > Robert Haas writes: >> On Wed, Apr 20, 2011 at 7:13 PM, Tom Lane wrote: >>> I have stated previously my opinion that this is a misconceived feature, >>> and it's now apparent that the implementation is as poorly thought >>> through as the defin

Re: [BUGS] BUG #5988: CTINE duplicates constraints

2011-04-25 Thread Tom Lane
Robert Haas writes: > On Wed, Apr 20, 2011 at 7:13 PM, Tom Lane wrote: >> I have stated previously my opinion that this is a misconceived feature, >> and it's now apparent that the implementation is as poorly thought >> through as the definition.  My recommendation is to revert that patch >> alto

Re: [BUGS] BUG #5988: CTINE duplicates constraints

2011-04-25 Thread Robert Haas
On Wed, Apr 20, 2011 at 7:13 PM, Tom Lane wrote: > "Marko Tiikkaja" writes: >> CREATE TABLE IF NOT EXISTS duplicates some constraints if the new table >> isn't created: > > What this means is that the feature was implemented in the wrong place, > ie the short-circuit is after rather than before p

Re: [BUGS] BUG #5988: CTINE duplicates constraints

2011-04-20 Thread Tom Lane
"Marko Tiikkaja" writes: > CREATE TABLE IF NOT EXISTS duplicates some constraints if the new table > isn't created: What this means is that the feature was implemented in the wrong place, ie the short-circuit is after rather than before parse_utilcmds.c splits up the CREATE TABLE command into mul

[BUGS] BUG #5988: CTINE duplicates constraints

2011-04-20 Thread Marko Tiikkaja
The following bug has been logged online: Bug reference: 5988 Logged by: Marko Tiikkaja Email address: marko.tiikk...@2ndquadrant.com PostgreSQL version: git master Operating system: Linux Description:CTINE duplicates constraints Details: CREATE TABLE IF NOT EXISTS