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 problem is with triger. ----- Wiadomosc oryginalna ----- Od: "Andreas Wernitznig" <[EMAIL PROTECTED]> Do: "Pawel Pawlowski" <[EMAIL PROTECTED]> DW: <[EMAIL PROTECTED]> Wyslano: 29 sierpnia 2001 13:20 Temat: Re: [BUGS] PD: triggered data change violation on relation "tbl_b" > You cannot insert and delete the same data within one transaction. > Only one change of a row is allowed. > > Greetings > Andreas > > On Wed, 29 Aug 2001 13:18:02 +0200 > "Pawel Pawlowski" <[EMAIL PROTECTED]> wrote: > > > When I insert to table new row and after this in the same transaction I delete this row I get such error: > > triggered data change violation on relation "tbl_b" > > > > I've created database using simple script: > > > > CREATE TABLE tbl_a > > ( > > pn_id SERIAL, > > pn_a VARCHAR(400) NOT NULL, > > PRIMARY KEY (pn_id) > > ); > > CREATE TABLE tbl_b > > ( > > pc_id INT4 NOT NULL REFERENCES tbl_a (pn_id) ON UPDATE CASCADE ON DELETE CASCADE, > > pc_b VARCHAR(40) NOT NULL, > > PRIMARY KEY (pc_id, pc_b) > > ); > > INSERT INTO tbl_a VALUES (1, 'xxx'); > > > > And this is the sample script that I use to generete this bug: > > > > begin transaction; > > insert into tbl_b values (1, 'xxx'); > > delete from tbl_b where pc_id=1; > > ERROR: triggered data change violation on relation "tbl_b" > > > > How to solve this problem ????? > > > > ------------------------------ > Andreas Wernitznig > Insilico Software GmbH > E-Mail: [EMAIL PROTECTED] > Web: www.insilico.com > ------------------------------ > ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
