Re: Questions on RI spec (poss. bugs)

Peter Eisentraut wrote:
>
> 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.
>
Do we also get "Triggered data change violations" when we delete and
then
insert on the FK side in a single transaction ?

I just had to remove a FK constraint because I could not figure ot where
the violation was coming from ;(

-----------------
Hannu