Re: [HACKERS] Trigger drop/create bug?

Lobotomy stitches came loose again. D'oh! Different table names...

Cheers,
Ed Loehr

Ed Loehr wrote:
>
> 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