Re: [GENERAL] Problem with non-unique constraint names

2009-02-14 Thread Tom Lane
"Ken Winter" writes: > Since constraint name uniqueness is a SQL standard, I was surprised that > PostgreSQL doesn't enforce it. I found one thread (from 2002) in the > archive that discusses this, but the thread ended inconclusively. I think our position is pretty clear: we aren't going to enfo

Re: [GENERAL] Problem with non-unique constraint names

2009-02-14 Thread Scott Marlowe
I think your two alternatives are to either make sure no constraint names are duplicated, or add a unique key for conname to pg_constraint. I didn;t know constraint name was a SQL requirement. I can see how the information_schema would be designed to assume they were unique if it was. -- Sent vi