Re: [BUGS] BUG #8227: referential integrity problem

2013-06-12 Thread Tom Lane
g...@antrez.pl writes: > Is it ok that we loose referential integrity by locking DELETE on table > test_item ? Yes. If you put a trigger on a table involved in an FK constraint, it's your responsibility that the trigger doesn't break FK update operations. regards, tom lan

[BUGS] BUG #8227: referential integrity problem

2013-06-12 Thread greg
The following bug has been logged on the website: Bug reference: 8227 Logged by: Greg Brzezinski Email address: g...@antrez.pl PostgreSQL version: 9.2.4 Operating system: linux Description: postgres=# CREATE TABLE test( id int primary key, name text ); NOTICE: CREATE