Обсуждение: is there a hook by which we can modify input query before postgresql builds raw parse tree

Поиск
Список
Период
Сортировка
Hi,

   I want to know is there a way to use a hook to modify the input query before Postgresql parses and builds the parse tree for the query.



On Fri, May 2, 2014 at 10:07 AM, Rajmohan C <csrajmohan@gmail.com> wrote:
Hi,

   I want to know is there a way to use a hook to modify the input query before Postgresql parses and builds the parse tree for the query.

Uh...the rewriter?

--
Regards,
 
Atri
l'apprenant

Re: is there a hook by which we can modify input query before postgresql builds raw parse tree

От
Michael Paquier
Дата:
On Fri, May 2, 2014 at 1:37 PM, Rajmohan C <csrajmohan@gmail.com> wrote:
> Hi,
>
>    I want to know is there a way to use a hook to modify the input query
> before Postgresql parses and builds the parse tree for the query.
Not that I know of. I am not sure that enforcing query rewrite on the
server side is a good idea at this may trap your applications and have
them face unexpected behaviors.

FWIW, a presentation about hooks has been done at PGCon 2012, you can
refer to it as well for your future work:
http://wiki.postgresql.org/images/e/e3/Hooks_in_postgresql.pdf
-- 
Michael



Re: is there a hook by which we can modify input query before postgresql builds raw parse tree

От
Michael Paquier
Дата:
On Fri, May 2, 2014 at 2:06 PM, Michael Paquier
<michael.paquier@gmail.com> wrote:
> Not that I know of. I am not sure that enforcing query rewrite on the
> server side is a good idea at this may trap your applications and have
> them face unexpected behaviors.
Note as well that there is a hook *before* the rewriter and *after*
parse/analyze of query called post_parse_analyze_hook in
parser/analyze.h.
-- 
Michael