Jan Wieck writes:
> Stephan Szabo wrote:
> >
> > There's a message on -general about a possible
> > problem in the deferred RI constraints. He was doing a
> > sequence like:
> > begin
> > delete
> > insert
> > end
> > and having it fail even though the deleted key was back in
> > place at the end.
>
> Isn't that (delete and reinsert the same PK) what the
> standard means with "triggered data change violation"?
Triggered data change violations can only occur if the same attribute is
changed twice during the same *statement*, not transaction.
--
Peter Eisentraut peter_e(at)gmx(dot)net http://yi.org/peter-e/