Re: drop foreign key

Поиск
Список
Период
Сортировка
От Stephan Szabo
Тема Re: drop foreign key
Дата
Msg-id 20021221203033.X31857-100000@megazone23.bigpanda.com
обсуждение исходный текст
Ответ на drop foreign key  ("Madhavi" <madhavi@zoniac.com>)
Список pgsql-general
On Fri, 20 Dec 2002, Madhavi wrote:

> Can anybody please tell me how to drop a foreign key associated with a table
> in postgres7.2.3? Please give me the syntax and the query.

In 7.2.3 you'll need to find the three triggers associated with the key
and drop those with drop trigger (doublequoting the name because it's of
mixed case).  Techdocs has some information on foreign keys that will
probably be useful.


В списке pgsql-general по дате отправления:

Предыдущее
От: Jan Ploski
Дата:
Сообщение: Re: Unicode database + JDBC driver performance
Следующее
От: Graham Leggett
Дата:
Сообщение: Re: Unable to format timestamp with time zone; internal