[pgadmin-support] Trigger Refresh Error - PGAdmin

[Hart, Rob (FWP)]

Hello,
I'm not sure whether this is a PGAdmin bug or otherwise but I was able to 
replicate on different servers, though I haven't tested it in other versions of 
pgadmin.


PG Admin v1.14.3
"PostgreSQL 9.1.4 on x86_64-unknown-linux-gnu, compiled by gcc (SUSE Linux) 
4.3.4 [gcc-4_3-branch revision 152973], 64-bit"
SLES 11 SP2

To create error:
Right click on trigger object and select refresh.

[cid:image001.png@01CD8200.2BCB0A30]

Error details taken from log:

pgdev pgAdmin III - BrowserERROR:  syntax error at or near "AND" at character 
527
pgdev pgAdmin III - BrowserSTATEMENT:  SELECT t.oid, t.xmin, t.*, relname, CASE 
WHEN r
elkind = 'r' THEN TRUE ELSE FALSE END AS parentistable,   nspname, 
des.description, l.lanname, p.prosrc,
          substring(pg_get_triggerdef(t.oid), 'WHEN (.*) EXECUTE PROCEDURE') AS 
whenclause
          FROM pg_trigger t
          JOIN pg_class cl ON cl.oid=tgrelid
          JOIN pg_namespace na ON na.oid=relnamespace
          LEFT OUTER JOIN pg_description des ON des.objoid=t.oid
          LEFT OUTER JOIN pg_proc p ON p.oid=t.tgfoid
          LEFT OUTER JOIN pg_language l ON l.oid=p.prolang
         WHERE NOT tgisinternal AND

           AND t.tgname='ces_contact_audit' AND cl.oid=17731::oid AND 
cl.relnamespace=17441::oid::oid
         ORDER BY tgname

Please let me know if you require any further details.
Kind Regards,
Robert Hart

<<inline: image001.png>>