Postgres Pro
Downloads
Home   >   mailing lists

Thread: Delete a FOREIGN KEY

Delete a FOREIGN KEY

From
"Marcelo Henrique da Silva"
Date:
Hi All,
 
I'm beginner in PostgreSQL!
So, how can I delete a FOREIGN KEY in PostgreSQL?
 
Thanks.
 
Marcelo Henrique da Silva.

Re: Delete a FOREIGN KEY

From
Stephan Szabo
Date:
On Tue, 30 Jul 2002, Marcelo Henrique da Silva wrote:

> Hi All,
>
> I'm beginner in PostgreSQL!
> So, how can I delete a FOREIGN KEY in PostgreSQL?

You'll need to drop the triggers related to the foreign key.
You might want to look at the referential integrity documents
on techdocs.postgresql.org.