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?
"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