Re: Access to dynamic SQL in PL/pgSQL - Mailing list pgsql-hackers

From Pavel Stehule
Subject Re: Access to dynamic SQL in PL/pgSQL
Date
Msg-id 162867791001220241l6e85de5eh658724f8e70dbbd0@mail.gmail.com
Whole thread Raw
In response to Access to dynamic SQL in PL/pgSQL  (Simon Riggs <simon@2ndQuadrant.com>)
Responses Re: Access to dynamic SQL in PL/pgSQL  (Simon Riggs <simon@2ndQuadrant.com>)
List pgsql-hackers
2010/1/22 Simon Riggs <simon@2ndquadrant.com>:
>
> 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.

can you show some example, please?

Pavel

>
> 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
>


pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Access to dynamic SQL in PL/pgSQL
Next
From: Simon Riggs
Date:
Subject: Re: Access to dynamic SQL in PL/pgSQL