Re: Odp: [BUGS] PD: triggered data change violation on relation

2001-09-03 Thread Stephan Szabo
On Mon, 3 Sep 2001, Tom Lane wrote: > Stephan Szabo <[EMAIL PROTECTED]> writes: > > This was a mistake in the interpretation of the spec (modification of > > the same key row referenced by a foreign key constraint in the same > > statement more than once is an error is how we believe the spec me

Re: Odp: [BUGS] PD: triggered data change violation on relation "tbl_b"

2001-09-03 Thread Tom Lane
Stephan Szabo <[EMAIL PROTECTED]> writes: > This was a mistake in the interpretation of the spec (modification of > the same key row referenced by a foreign key constraint in the same > statement more than once is an error is how we believe the spec meant > it, but there's a case where they mentio

Re: Odp: [BUGS] PD: triggered data change violation on relation"tbl_b"

2001-08-29 Thread Stephan Szabo
This was a mistake in the interpretation of the spec (modification of the same key row referenced by a foreign key constraint in the same statement more than once is an error is how we believe the spec meant it, but there's a case where they mention transaction and it got misinterpreted). I don'

Odp: [BUGS] PD: triggered data change violation on relation "tbl_b"

2001-08-29 Thread Pawel Pawlowski
Im changing now database from Interbase 6.0 to PosgreSql 7.1.2. With IB there is no problem to do such things. This problem only exist when I create table tbl_a with references (REFERENCES tbl_a (pn_id) ON UPDATE CASCADE ON DELETE CASCADE). Without this part everything works OK. So I think that pr