Re: Trigger Refresh Error - PGAdmin

On Fri, 2012-08-24 at 20:04 +0000, Hart, Rob (FWP) wrote:
> 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(dot)png(at)01CD8200(dot)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.

This is a pgAdmin's bug for sure. It's now fixed (in 1.16 and in the dev
branch).

Thanks for your report.

--
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com