Re: How to drop an trigger

Поиск
Список
Период
Сортировка
От Frank Joerdens
Тема Re: How to drop an trigger
Дата
Msg-id 20010308170629.A16771@rakete.joerdens.de
обсуждение исходный текст
Ответ на How to drop an trigger  (Frank Joerdens <frank@joerdens.de>)
Ответы Re: Re: How to drop an trigger  (Frank Joerdens <frank@joerdens.de>)
Список pgsql-sql
On Thu, Mar 08, 2001 at 04:42:46PM +0100, Frank Joerdens wrote:
> I've created quite a few foreign key constraints in the database that I
> am currently working on, and now that I've altered the structure and
> dropped a table that had a foreign key reference to a couple of other
> tables, I need to get rid of those foreign keys (they weren't dropped
> automagically with the table), as I get errors on trying to update those
> tables.

Just an idea: Is it safe to just delete the corresponding row in
pg_trigger?

Regards, Frank


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

Предыдущее
От: "Josh Berkus"
Дата:
Сообщение: Re: No Documentation for to_char(INTERVAL, mask)
Следующее
От: Najm Hashmi
Дата:
Сообщение: Re: quotes in pl/pgsql 0n variable type text or varchar