| 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
| 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) |