| From: | "Pawel Pawlowski" <pawel(dot)pawlowski(at)breitenbach(dot)pl> | 
|---|---|
| To: | <pgsql-bugs(at)postgresql(dot)org> | 
| Subject: | PD: triggered data change violation on relation "tbl_b" | 
| Date: | 2001-08-29 11:18:02 | 
| Message-ID: | 004f01c1307c$44c391b0$3200000a@breitenbach.pl | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | pgsql-bugs | 
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 ?????
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andreas Wernitznig | 2001-08-29 11:20:54 | Re: PD: triggered data change violation on relation "tbl_b" | 
| Previous Message | Pawel Pawlowski | 2001-08-29 11:00:38 | BUG: triggered data change violation on relation "tbl_b" |