Deferrable check constraints

From: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
To: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Deferrable check constraints
Date: 2016-02-21 02:05:06
Message-ID: CAMkU=1y+=hy+Z=bwB4w+=ktuw4bHZMP+JakY-B7gNDm2ZDAqBg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

I recently wished for deferrable check constraints while doing some
crash-recovery stress testing.

I don't know how important they would be for real-world cases, but the
SQL standard does seem to require them, so I think they would be
desirable just for that reason.

There isn't an entry for this on the wiki TODO list. I wanted to add
an entry, but I can't find any mail threads to link to about why this
isn't wanted, isn't possible, or isn't easy. Or for that matter, *is*
easy, but no one has gotten around to it.

Is there some canonical discussion on this topic that I'm not aware
of? (The mail archive search interface is not so helpful with common
words like "check".)

Cheers,

Jeff

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2016-02-21 02:16:38 Re: Deferrable check constraints
Previous Message Tom Lane 2016-02-21 00:40:57 Re: [Pgbuildfarm-members] Release 4.17 of the PostgreSQL Buildfarm client