Thread: [pgAdmin III] #240: Trigger Display Bugs in 1.12 pgAdmin
#240: Trigger Display Bugs in 1.12 pgAdmin -------------------------------------+-------------------------------------- Reporter: Christopher A Hotchkiss | Owner: gleu Type: bug | Status: new Priority: minor | Milestone: Component: pgadmin | Version: 1.12 Keywords: browser | Platform: all -------------------------------------+-------------------------------------- I am using the new 1.12 pgAdmin on Windows XP SP3 and I have notice two display inaccuracies when connecting to a Postgres 9 database. For example when creating the following trigger: CREATE TRIGGER c_aud_trg BEFORE INSERT OR UPDATE OR DELETE ON ca FOR EACH ROW EXECUTE PROCEDURE c_aud_trg_trfunc(); It will get created correctly (checking with pgdump based on suggestions from the pgsql list). However it will be displayed as: CREATE TRIGGER c_aud_trg BEFORE INSERT OR UPDATE ON ca FOR EACH ROW EXECUTE PROCEDURE c_aud_trg_func(E'\\x'); If that same trigger is dropped and re-added using what is in the database, the following shows up: CREATE TRIGGER c_aud_trg BEFORE INSERT OR UPDATE ON ca FOR EACH ROW EXECUTE PROCEDURE c_aud_trg_func(E'\\x5c7800'); The second issue is the ordering of 'update of' triggers. For example when creating the following trigger: CREATE TRIGGER ca_trig BEFORE UPDATE OF columnA OR DELETE ON ca FOR EACH ROW EXECUTE PROCEDURE c_h_trg_func (); It will be displayed as: CREATE TRIGGER ca_trig BEFORE UPDATE OR DELETE OF columnA ON ca FOR EACH ROW EXECUTE PROCEDURE c_h_trg_func (); This is a syntax error. -- Ticket URL: <http://code.pgadmin.org/trac/ticket/240> pgAdmin III <http://code.pgadmin.org/trac/> pgAdmin III
#240: Trigger Display Bugs in 1.12 pgAdmin --------------------------------------+------------------------------------- Reporter: Christopher A Hotchkiss | Owner: gleu Type: bug | Status: closed Priority: minor | Milestone: 1.12.1 Component: pgadmin | Version: 1.12 Resolution: fixed | Keywords: browser Platform: all | --------------------------------------+------------------------------------- Changes (by gleu): * status: new => closed * resolution: => fixed * milestone: => 1.12.1 -- Ticket URL: <http://code.pgadmin.org/trac/ticket/240#comment:1> pgAdmin III <http://code.pgadmin.org/trac/> pgAdmin III