Re: Create a deferrably-unique index

From: Paul Jungwirth <pj(at)illuminatedcomputing(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql <pgsql-general(at)postgresql(dot)org>
Subject: Re: Create a deferrably-unique index
Date: 2013-08-19 18:43:57
Message-ID: CA+6hpa=eoeL=NcTRnJPy5ZDrhm2fpXpmF4LTKq_wawFSkdJayw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2013-08-19 19:01:34 Re: Create a deferrably-unique index
Previous Message Tom Lane 2013-08-19 18:34:21 Re: Create a deferrably-unique index