[HACKERS] Trigger drop/create bug?
От | Ed Loehr |
---|---|
Тема | [HACKERS] Trigger drop/create bug? |
Дата | |
Msg-id | 3891EE89.F9EF18DB@austin.rr.com обсуждение исходный текст |
Список | pgsql-hackers |
The following drop fails due to non-existent trigger, but then the subsequent create fails due to existing trigger. What's happening? Is this a known problem? Pg 6.5.2, RH6.1, 2.2.12-20smp, Pentium III i686 (from my postgres server log...) 20000128.13:21:05.881 [2810] query: DROP TRIGGER ems_user_insert_trigger ON employee; 20000128.13:21:05.881 [2810] ProcessUtility: DROP TRIGGER ems_user_insert_trigger ON employee; 20000128.13:21:05.881 [2810] ERROR: DropTrigger: there is no trigger ems_user_insert_trigger on relation employee 20000128.13:21:05.882 [2810] query: CREATE TRIGGER ems_user_insert_trigger AFTER INSERT ON ems_user FOR EACH ROW EXECUTE PROCEDURE add_bad_passwd_rec(); 20000128.13:21:05.882 [2810] ProcessUtility: CREATE TRIGGER ems_user_insert_trigger AFTER INSERT ON ems_user FOR EACH ROW EXECUTE PROCEDURE add_bad_passwd_rec(); 20000128.13:21:05.883 [2810] ERROR: CreateTrigger: trigger ems_user_insert_trigger already defined on relation ems_user Cheers, Ed Loehr
В списке pgsql-hackers по дате отправления: