Tom Lane wrote: > ... I think it might be interesting to turn > around Jeff's syntax sketch and provide a way to say that a CONSTRAINT > declaration should depend on some previously added index, eg > something like > > ALTER TABLE tab ADD CONSTRAINT UNIQUE (col1, col2) USING index >
Is there any reason to limit UNIQUE constraints to lists of table columns? If you can build a unique index on an expression, why not a unique constraint? A quick test defining an index and manually adding catalog entries for the constraint and depends showed that it appears to work fine (and it's compatible with my deferrable unique constraints patch :-) ) - Dean -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
