Re: referential integrity constraints not checked inside - Mailing list pgsql-general

From Tom Lane
Subject Re: referential integrity constraints not checked inside
Date
Msg-id 8279.1084457368@sss.pgh.pa.us
Whole thread Raw
In response to Re: referential integrity constraints not checked inside  (Christian Rank <christian.rank@rz.uni-passau.de>)
Responses Re: referential integrity constraints not checked inside  (Christian Rank <christian.rank@rz.uni-passau.de>)
List pgsql-general
Christian Rank <christian.rank@rz.uni-passau.de> writes:
> ... according to the docs, the validity of a constraint should be
> checked after each statement unless this behaviour is altered with a SET
> CONSTRAINTS statement.

"Statement" means "interactive command" in that context --- in other
words, the constraints won't be checked until after control returns from
your function.

            regards, tom lane

pgsql-general by date:

Previous
From: Christopher Browne
Date:
Subject: Re: referential integrity constraints not checked inside PL/pgSQL functions?
Next
From: Christian Rank
Date:
Subject: Re: referential integrity constraints not checked inside