Re: [BUGS] lost on referentail integrity

2006-12-16 Thread Tom Lane
Patrice Beliveau <[EMAIL PROTECTED]> writes: > The problem is very simple to reproduce: [ shrug... ] Your trigger suppressed the cascaded deletes. What were you expecting to happen? regards, tom lane ---(end of broadcast)-

[BUGS] lost on referentail integrity

2006-12-16 Thread Patrice Beliveau
Hi, I'm using PostgreSQL 8.1.4 The problem is very simple to reproduce: create table test1 ( pk1 text not null, df1 text, primary key(pk1) ); create table test2 ( pk1 text not null, pk2 text not null, df2 text, primary key(pk1,pk2) ); alter table test2 add constraint c1 foreign