Skip site navigation (1) Skip section navigation (2)

[pgAdmin III] #240: Trigger Display Bugs in 1.12 pgAdmin

From: "pgAdmin Trac" <trac(at)code(dot)pgadmin(dot)org>
To:
Cc: pgadmin-hackers(at)postgresql(dot)org
Subject: [pgAdmin III] #240: Trigger Display Bugs in 1.12 pgAdmin
Date: 2010-09-24 20:44:08
Message-ID: 064.1b6ef2dc31c68b68f51d042e73288236@code.pgadmin.org (view raw or flat)
Thread:
Lists: pgadmin-hackers
#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

Responses

pgadmin-hackers by date

Next:From: Guillaume LelargeDate: 2010-09-25 06:29:37
Subject: pgAdmin III commit: Fix the reverse-engineered query for triggers
Previous:From: Guillaume LelargeDate: 2010-09-24 20:28:31
Subject: pgAdmin III commit: Add .gitignore files.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group