Re: Fetch JSONB Value for UNIQUE Constraint

From: "David E(dot) Wheeler" <david(at)justatheory(dot)com>
To: Peter Geoghegan <pg(at)bowt(dot)ie>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Fetch JSONB Value for UNIQUE Constraint
Date: 2017-03-25 00:11:51
Message-ID: C2F3D3B7-66F7-40D5-9B54-6BBAE6D697A4@justatheory.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Mar 24, 2017, at 5:00 PM, Peter Geoghegan <pg(at)bowt(dot)ie> wrote:

>> So it’s a fine workaround, but maybe there’s something missing from the parsing of the CREATE TABLE statement? This is on 9.6.1.
>
> Unique constraints don't support expressions, or a predicate (partial-ness).

Oh. Okay. I assumed the syntax would be identical to a unique index, since that’s ultimately what a unique constraint is, IIUC. My mistake.

Thanks Peter!

Best,

David

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Geoghegan 2017-03-25 00:44:35 Re: ICU integration
Previous Message Craig Ringer 2017-03-25 00:08:01 Re: [PATCH] Transaction traceability - txid_status(bigint)