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" <andreas@insilico.com>
Do: "Pawel Pawlowski" <pawel.pawlowski@breitenbach.pl>
DW: <pgsql-bugs@postgresql.org>
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" <pawel.pawlowski@breitenbach.pl> 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: andreas@insilico.com
> Web: www.insilico.com
> ------------------------------
>
