Postgres Pro
Downloads
Home   >   mailing lists

Thread: unique indices without pg_constraint rows

unique indices without pg_constraint rows

From
"Ed L."
Date:

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

From
Tom Lane
Date:
"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