Re: orphaned trigger

Поиск
Список
Период
Сортировка
От Jonathan Ellis
Тема Re: orphaned trigger
Дата
Msg-id 00e601c0de5b$991d2c30$5a050a0a@devjellis
обсуждение исходный текст
Ответ на Re: orphaned trigger  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Ответы Re: orphaned trigger  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Список pgsql-bugs
> > Would manually
> > removing it from pg_trigger cause Bad Things to happen?
>
> Yes, and you'll need to double quote the trigger name.
> try
> drop trigger "RI_ConstraintTrigger_44349" on users;

That worked.  Why was that?

> How did you drop the table?  Did you reload a dump file (like the one that
> referenced it)?

I'm afraid I don't understand the question.  I dropped it with drop table.
Although thinking back on it, the drop may have been on 7.0.2.  Can't
remember whether that was before or after upgrading...

-Jonathan

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

Предыдущее
От: Stephan Szabo
Дата:
Сообщение: Re: orphaned trigger
Следующее
От: Tom Lane
Дата:
Сообщение: Re: date bug