Re: Fetch JSONB Value for UNIQUE Constraint

From: Peter Geoghegan <pg(at)bowt(dot)ie>
To: "David E(dot) Wheeler" <david(at)justatheory(dot)com>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Fetch JSONB Value for UNIQUE Constraint
Date: 2017-03-25 00:00:05
Message-ID: CAH2-Wz=7Cxe5GwwXbZ1JdcfmQPGFNQvHcfGwam2jD3VBOM3X6A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Fri, Mar 24, 2017 at 4:57 PM, David E. Wheeler <david(at)justatheory(dot)com> 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).

--
Peter Geoghegan

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Craig Ringer 2017-03-25 00:08:01 Re: [PATCH] Transaction traceability - txid_status(bigint)
Previous Message David E. Wheeler 2017-03-24 23:57:38 Fetch JSONB Value for UNIQUE Constraint