It's not currently possible to access the SQL used in a dynamic PL/pgSQL statement using a PL/pgSQL plugin.
In src/pl/plpgsql/src/pl_exec.c's exec_stmt() we call each dynamic statement type, evaluate the SQL and free memory again before the plugin gains control again. It seems simple to attach querystr to PLpgSQL_execstate and free it after the plugin has seen it. The difference in lifetime of the memory allocation is very small. Would a patch to make this simple change be acceptable? It would need to be backpatched to 8.1 also? -- Simon Riggs www.2ndQuadrant.com -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
