Re: finding and removing a constraint...

Поиск
Список
Период
Сортировка
От Stephan Szabo
Тема Re: finding and removing a constraint...
Дата
Msg-id Pine.BSF.4.21.0103201335540.30635-100000@megazone23.bigpanda.com
обсуждение исходный текст
Ответ на finding and removing a constraint...  ("chris markiewicz" <cmarkiew@commnav.com>)
Список pgsql-general
On Tue, 20 Mar 2001, chris markiewicz wrote:

> hello
>
> i am trying to remove a foreign key that i placed on a database.  what is
> the easiest way to find/delete the constraint?

The constraint will generate three triggers in pg_trigger.  You can find
the correct triggers by looking at the trigger arguments and then you
should be able to drop those triggers (note: one of the triggers is on the
referencing table, the other two are on the referenced table.)


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

Предыдущее
От: "chris markiewicz"
Дата:
Сообщение: RE: finding and removing a constraint...
Следующее
От: Stephan Szabo
Дата:
Сообщение: Re: RE: finding and removing a constraint...