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.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.
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 -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
