pgAdmin III commit: Fix the reverse-engineered query for triggers

From: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
To: pgadmin-hackers(at)postgresql(dot)org
Subject: pgAdmin III commit: Fix the reverse-engineered query for triggers
Date: 2010-09-25 06:29:37
Message-ID: 201009250629.o8P6TbLY082534@gothos.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-hackers

Fix the reverse-engineered query for triggers

The new "OF column" syntax is only available for UPDATE, and we should check
the args only if the number of args is not zero.

Set the bytea_output parameter to its old value on 9.0 right after a
connection. The tgargs column is of type bytea and bytea_output, new parameter
in 9.0, makes it quite unreadable if we don't set bytea_output to 'escape'.

Report from Christopher A Hotchkiss.

Fixed #240.

Branch
------
master

Details
-------
http://git.postgresql.org/gitweb?p=pgadmin3.git;a=commitdiff;h=18cb205d16c5031236ca20e602ae4e67faa63fa3

Modified Files
--------------
pgadmin/db/pgConn.cpp | 8 ++++++--
pgadmin/schema/pgTrigger.cpp | 11 ++++++-----
2 files changed, 12 insertions(+), 7 deletions(-)

Browse pgadmin-hackers by date

  From Date Subject
Next Message pgAdmin Trac 2010-09-25 06:31:19 Re: [pgAdmin III] #240: Trigger Display Bugs in 1.12 pgAdmin
Previous Message pgAdmin Trac 2010-09-24 20:44:08 [pgAdmin III] #240: Trigger Display Bugs in 1.12 pgAdmin