Robert Haas <robertmh...@gmail.com> writes:
> On Thu, Nov 8, 2012 at 4:45 AM, <andr...@officenet.no> wrote:
>> Are there any plans to include DEFERRABLE NOT NULL constraints in 9.3 so one
>> can do this?
>>
>> create table test(a varchar not null deferrable initially deferred);
>>
>> This works in Oracle and is quite handy when working with ORMs.
> Not to my knowledge ... although I can't claim to know everything that
> anyone is working on.
You could get the effect by applying the not-null check in a custom
constraint trigger. A bit tedious but it'd work.
regards, tom lane
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
