While running the following set of statements: create table category ( category_id serial not null primary key, category_name text not null, company_id int references company on delete cascade, cattype_id int not null references cattype, category_parent_id int not null references category ); begin work; insert into category (category_id, category_name, company_id, cattype_id, category_parent_id ) values (300, 'u2', 4, 25, 0 ); delete from category where category_id = 300; we get the error: ERROR: triggered data change violation on relation "category" It goes away when we remove all the references from the table definition, and isn't a problem outside a transaction, but we'd really like it to work inside the transaction. What's the reason for the error and how can we fix it? -- Matt Beauregard Information Technology Operations, DesignScape Ph: +61 2 9361 4233 Fx: +61 2 9361 4633
