Hi Ricardo, I assume you're talking about foreign key constraints?
Dropping a constraint is a real pain in all versions of Postgres up to and including 7.2.1. You will need to manually drop the RI trigger on the child table and the two triggers on the parent table. Techdocs has some information on doing this here: http://techdocs.postgresql.org/techdocs/hackingreferentialintegrity.php Chris > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]]On Behalf Of Ricardo Javier > Aranibar León > Sent: Wednesday, 3 July 2002 4:08 AM > To: [EMAIL PROTECTED] > Subject: [SQL] constraint > > > > > Hi list, > I need your help. > How I can delete or DROP a constraint? > I use POSTGRESQL 7.0.3 > > _________________________________________________________________ > MSN. Más Útil cada Día. http://www.msn.es/intmap/ > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org > > ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
