[HACKERS] Problem with foreign keys (performance and deadlocks)

2003-03-04 Thread Brian Walker
I posted this message to psql-bugs in December but I have not heard if this has been fixed or not. This is holding up our development and testing of our product using Linux and PostgreSQL. Thanks ** ORIGINAL MESSAGE *** Sorry for this being so long but I want to describ

[HACKERS] problem with foreign keys

2000-11-20 Thread Malek Shabou
Hi, i have a problem with REFERENCES (foreign keys). i have this table: drop table paragraph; create table paragraph ( id int4 PRIMARY KEY, label varchar(512), paragraph_next int4 CONSTRAINT paragraph_fk_next REFERENCES paragraph DEFERRABLE INITIALLY DEFERRED, paragraph_priv int4 CONSTR