"Ken Winter" <ken@xxxxxxxxxxx> 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 enforce it. The PG code does avoid choosing default constraint names that duplicate an existing constraint. So if you have this situation it's presumably because you explicitly named two constraints the same. Solution, of course, is don't do that if you need them to not be the same. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
