Re: referential integrity constraints not checked inside

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Christian Rank <christian(dot)rank(at)rz(dot)uni-passau(dot)de>
Cc: Patrick Welche <prlw1(at)newn(dot)cam(dot)ac(dot)uk>, pgsql-general(at)postgresql(dot)org
Subject: Re: referential integrity constraints not checked inside
Date: 2004-05-13 14:09:28
Message-ID: 8279.1084457368@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Christian Rank <christian(dot)rank(at)rz(dot)uni-passau(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Christian Rank 2004-05-13 14:19:17 Re: referential integrity constraints not checked inside
Previous Message Tom Lane 2004-05-13 13:10:23 Re: pg_xlog becomes extremely large during CREATE INDEX