Re: [GENERAL] A Referntial integrity

2000-07-08 Thread Alex Bolenok
> Hello, > > We are using a postgresql-7.0.2. Consider the following scenario > > we have created a table t1 with columns > > c1 : having referential integrity with t2.c1 > c2 : having referential integrity with t3.c2 > > where t2 and t3 are different tables > > Assume that t2 has also got

Re: [GENERAL] A Referntial integrity

2000-07-07 Thread Stephan Szabo
Actually, you should (hopefully) be able to drop t2. That is supposed to remove the constraints referencing it (technically speaking drop table is probably supposed to take an argument to determine whether to do this, but we don't yet). If it's actually failing for you, can you give us a copy o