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

Fri, 28 Jan 2000 13:31:21 -0600
Ed Loehr <eloehr@austin.rr.com>
[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

Fri, 28 Jan 2000 13:33:40 -0600
Ed Loehr <eloehr@austin.rr.com>
Re: [HACKERS]  Trigger drop/create bug?