<david.sahagian@xxxxxxx> writes: > -- This blows up. -- SQL state: 42809 -- ERROR: "array_agg" is an aggregate function > select > TRG.tgname, TFX.proname, pg_get_functiondef(TFX.oid) as fdef > from > pg_trigger TRG > inner join pg_proc TFX on TFX.oid = TRG.tgfoid > where > TRG.tgisinternal = true > and > pg_get_functiondef(TFX.oid) = 'whatever' > Can you help me understand why this blows up ? The second part of the WHERE clause can be evaluated against pg_proc rows for which pg_get_functiondef() will fail. An easy workaround would be to use TRG.tgfoid instead, so that the WHERE clause gets pushed down to the other table. There probably shouldn't be any entries in pg_trigger for which pg_get_functiondef() will fail. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
