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
|
| Список | 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 по дате отправления: