Re: Re: Deferred NOT NULL? - Mailing list pgsql-general

From Tom Lane
Subject Re: Re: Deferred NOT NULL?
Date
Msg-id 10826.982777958@sss.pgh.pa.us
Whole thread Raw
In response to Re: Deferred NOT NULL?  ("Gregory Wood" <gregw@com-stock.com>)
List pgsql-general
"Gregory Wood" <gregw@com-stock.com> writes:
> Hmmmm, I just found a clearer grammar description in the docs and it appears
> that only REFERENCES constraints are deferrable in PostgreSQL. I suppose
> I'll have to handle this via a trigger for now.

> The book mentions that SQL92 allows for deferrable NOT NULL constraints. Is
> this planned for anytime soon?

This is (or should be) on the TODO list, but I don't know of anyone with
near-term plans to fix it.  The whole area of constraints could use an
overhaul, see past discussions in pghackers.

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: C function woes
Next
From: Tom Lane
Date:
Subject: Re: AllocSetAlloc()