Access to dynamic SQL in PL/pgSQL
| От | Simon Riggs |
|---|---|
| Тема | Access to dynamic SQL in PL/pgSQL |
| Дата | |
| Msg-id | 1264156365.4043.14197.camel@ebony обсуждение исходный текст |
| Ответы |
Re: Access to dynamic SQL in PL/pgSQL
Re: Access to dynamic SQL in PL/pgSQL Re: Access to dynamic SQL in PL/pgSQL |
| Список | pgsql-hackers |
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
В списке pgsql-hackers по дате отправления: