Re: thoughts about constraint trigger

On 15/06/10 02:33, Adrian von Bidder wrote:
> Heyho!
>
> I was trying to implement a deferred NOT NULL constraint using a deferred
> constraint trigger (on update and insert of this row) because some values
> would be filled in later during the transaction, after the initial part of
> the record has been filled.

AFAIK, at this point only FOREIGN KEY constraints may be deferred.

http://www.postgresql.org/docs/current/static/sql-set-constraints.html
http://www.postgresql.org/docs/current/static/sql-createtable.html

"DEFERRABLE
NOT DEFERRABLE

    This controls whether the constraint can be deferred. A constraint
that is not deferrable will be checked immediately after every command.
Checking of constraints that are deferrable can be postponed until the
end of the transaction (using the SET CONSTRAINTS command). NOT
DEFERRABLE is the default. Only foreign key constraints currently accept
this clause. All other constraint types are not deferrable."

--
Craig Ringer

Tech-related writing: http://soapyfrogs.blogspot.com/