Re: adddepend and partial indexes - Mailing list pgsql-general

From Tom Lane
Subject Re: adddepend and partial indexes
Date
Msg-id 13024.1055863846@sss.pgh.pa.us
Whole thread Raw
In response to Re: adddepend and partial indexes  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
List pgsql-general
Stephan Szabo <sszabo@megazone23.bigpanda.com> writes:
> AFAIK there's no such thing as a partial unique constraint so the index
> should probably just be left alone.

Yeah, that seems like a bug in adddepend --- it shouldn't try to
transform *all* unique indexes into unique constraints, only those
that can be expressed in the constraint syntax.  So, no partial
indexes, no functional indexes, no non-btree indexes, and no
non-default opclasses.  Rod, do you have time to fix that?

            regards, tom lane

pgsql-general by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: adddepend and partial indexes
Next
From: SZUCS Gábor
Date:
Subject: Re: adddepend and partial indexes