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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
