Weird in PGAdmin behavior for triggers of the same kind. - Mailing list pgadmin-support

From Ludwig Lim
Subject Weird in PGAdmin behavior for triggers of the same kind.
Date
Msg-id 20021115111903.60890.qmail@web80306.mail.yahoo.com
Whole thread Raw
List pgadmin-support
Hi:

  I am experiencing a weird problem having with
PGAdmin when I am viewing the body of the 2 triggers
of the same kind (2 AFTER UPDATE triggers):

  The following is what I get from screen :
-- Trigger: tu_sc_redeem ON sc_redeem
CREATE TRIGGER "tu_sc_redeem" AFTER INSERTUPDATE ON
"sc_redeem"
FOR EACH ROW EXECUTE PROCEDURE f_tu_sc_redeem();

-- Trigger: tu_sc_redeem_fspdet ON sc_redeem
CREATE TRIGGER "tu_sc_redeem_fspdet" AFTER
INSERTUPDATEUPDATE ON "sc_redeem"
FOR EACH ROW EXECUTE PROCEDURE
f_tu_sc_redeem_fspdet();

    Note that the INSERTUPDATE and INSERTUPDATEUPDATE
are not  typos. I just copy and paste it from the
"definition window" in PGAdmin

   I tried to drop and recreate the trigger in psql
(after making that both of are AFTER UPDATE TRIGGERS
only)  but still the same thing happened. This
phenomena has not occured on tables having more than
triggers of diffrent type.

    I hope the following might be of some help:

SELECT  tgname,tgtype
FROM pg_trigger
WHERE tgname IN
('tu_sc_redeem_fspdet','tu_sc_redeem');

       tgname        | tgtype
---------------------+--------
 tu_sc_redeem        |     17
 tu_sc_redeem_fspdet |     17

PGAdmin version : PGAdmin II v 1.2.0

Thank you in advance,
ludwig.


__________________________________________________
Do you Yahoo!?
New DSL Internet Access from SBC & Yahoo!
http://sbc.yahoo.com

pgadmin-support by date:

Previous
From: "Dave Page"
Date:
Subject: Re: a question
Next
From: "Dave Page"
Date:
Subject: Re: Weird in PGAdmin behavior for triggers of the same kind.