Re: Create a deferrably-unique index - Mailing list pgsql-general

From Paul Jungwirth
Subject Re: Create a deferrably-unique index
Date
Msg-id CA+6hpa=eoeL=NcTRnJPy5ZDrhm2fpXpmF4LTKq_wawFSkdJayw@mail.gmail.com
Whole thread Raw
In response to Re: Create a deferrably-unique index  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Create a deferrably-unique index  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
> Deferrability is a property of a constraint, not an index

Yes, but creating a unique constraint implicitly creates an index, and
creating a unique index implicitly creates a constraint. So I'm
wondering whether I can create a pair where the index is partial and
the constraint is deferrable. It sounds like the answer is no? Is
there a workaround where I first create one and then alter the other
one?

Thanks,
Paul

--
_________________________________
Pulchritudo splendor veritatis.


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Create a deferrably-unique index
Next
From: Tom Lane
Date:
Subject: Re: Create a deferrably-unique index