unique indices without pg_constraint rows
Started by Ed L.about 13 years ago2 messagesgeneral
I've been looking at unique indices in a PostgreSQL 8.3.x cluster. Some
unique indices clearly have a corresponding row in pg_constraint, while
other unique indices appear to have no corresponding row in
pg_constraint at all.
Why is this? What determines if a unique index will also have a row in
pg_constraint?
Thanks in advance.
Ed
Re: unique indices without pg_constraint rows
"Ed L." <pgsql@bluepolka.net> writes:
Why is this? What determines if a unique index will also have a row in
pg_constraint?
If you made it with constraint syntax, it'll have such a row.
If you made it with CREATE INDEX, not.
regards, tom lane
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general