Postgres Pro
Downloads
Home   >   mailing lists

Re: unique indices without pg_constraint rows - Mailing list pgsql-general

From Tom Lane
Subject Re: unique indices without pg_constraint rows
Date
Msg-id 6884.1364599852@sss.pgh.pa.us
Whole thread Raw
In response to unique indices without pg_constraint rows  ("Ed L." <pgsql@bluepolka.net>)
List pgsql-general
Tree view 
"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

pgsql-general by date:

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