Re: [GENERAL] unique indices without pg_constraint rows

2013-03-29 Thread Tom Lane
"Ed L." 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 (pg

[GENERAL] unique indices without pg_constraint rows

2013-03-29 Thread Ed L.
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