Dan Colish writes:
> I wanted to work on this todo item and I have a few questions about
> the semantics of it. Essentially, it is not possible to have more than
> one relname for a constraint,
That is per SQL spec: SQL92 10.6 syntax rule 2 saith
2) The of shall be differ-
I wanted to work on this todo item and I have a few questions about the
semantics of it. Essentially, it is not possible to have more than one relname
for a constraint, even though the comment in trigger.c says otherwise. I have
used this code to test this:
<<<
CREATE TABLE products (
I see what went wrong in my example. Unique constraints must have unique names
since they create an index. I'll try again, sorry for the noise.
--Dan
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgs