Hi!
It seems not possible to defer anything other than FOREIGN KEY
constraints. Is this true, and are there reasons for this?
What we want to do fill a record step by step, leaving some NOT NULL
columns empty in the first place and later in the transaction UPDATEing
them to contain some values. Collecting the values first would be
impractical as the update statements are somewhat scattered over various
modules of the program.
something like
avbidder=> create table blah ( fasel text not null deferrable initially
deferred ) ;
ERROR: Misplaced DEFERRABLE clause
should imho be possible (of course it doesn't make sense if there's only
one column, but this doesn't matter - the error persists).
any hints? thanks.
-- vbi
--
secure email with gpg avbidder@fortytwo.ch: key id 0x92082481
avbidder@acter.ch: key id 0x5E4B731F
