unique indices without pg_constraint rows

From: "Ed L(dot)" <pgsql(at)bluepolka(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: unique indices without pg_constraint rows
Date: 2013-03-29 23:04:42
Message-ID: 51561E0A.4010304@bluepolka.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Daniel Verite 2013-03-29 23:13:11 Re: Is there any way to listen to NOTIFY in php without polling?
Previous Message Gavan Schneider 2013-03-29 22:30:34 Re: Money casting too liberal?