Обсуждение: Delete a FOREIGN KEY

Поиск
Список
Период
Сортировка

Delete a FOREIGN KEY

От
"Marcelo Henrique da Silva"
Дата:
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

От
Stephan Szabo
Дата:
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.