Обсуждение: 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/
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: pgsql-sql-owner@postgresql.org > [mailto:pgsql-sql-owner@postgresql.org]On Behalf Of Ricardo Javier > Aranibar León > Sent: Wednesday, 3 July 2002 4:08 AM > To: pgsql-sql@postgresql.org > 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 > >