Postgres Pro
Downloads
Home   >   mailing lists

unique indices without pg_constraint rows - Mailing list pgsql-general

From Ed L.
Subject unique indices without pg_constraint rows
Date
Msg-id 51561E0A.4010304@bluepolka.net
Whole thread Raw
Responses Re: unique indices without pg_constraint rows
List pgsql-general
Tree view

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

pgsql-general by date:

Previous
From: Gavan Schneider
Date:
Subject: Re: Money casting too liberal?
Next
From: "Daniel Verite"
Date:
Subject: Re: Is there any way to listen to NOTIFY in php without polling?