Re: constraint

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(at)postgresql(dot)org
> [mailto:pgsql-sql-owner(at)postgresql(dot)org]On Behalf Of Ricardo Javier
> Aranibar León
> Sent: Wednesday, 3 July 2002 4:08 AM
> To: pgsql-sql(at)postgresql(dot)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
>
>