From: | Ed Loehr <eloehr(at)austin(dot)rr(dot)com> |
---|---|
To: | pghackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: [HACKERS] Trigger drop/create bug? |
Date: | 2000-01-28 19:33:40 |
Message-ID: | 3891EF14.FE33E6F7@austin.rr.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Brook Milligan | 2000-01-28 20:31:39 | Re: [HACKERS] END/ABORT |
Previous Message | Ed Loehr | 2000-01-28 19:31:21 | [HACKERS] Trigger drop/create bug? |