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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Guillaume Lelarge | 2010-09-25 06:29:37 | pgAdmin III commit: Fix the reverse-engineered query for triggers |
Previous Message | Guillaume Lelarge | 2010-09-24 20:28:31 | pgAdmin III commit: Add .gitignore files. |