Horton

Re: referential integrity constraints not checked inside

Tom Lane <tgl@sss.pgh.pa.us>

View thread View on postgr.es
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Christian Rank <christian.rank@rz.uni-passau.de>
Cc: Patrick Welche <prlw1@newn.cam.ac.uk>, pgsql-general@postgresql.org
Date: 2004-05-13T14:09:28Z
Lists: 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