Thread: is there a hook by which we can modify input query before postgresql builds raw parse tree
is there a hook by which we can modify input query before postgresql builds raw parse tree
From
Rajmohan C
Date:
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.
Re: is there a hook by which we can modify input query before postgresql builds raw parse tree
From
Atri Sharma
Date:
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
From
Michael Paquier
Date:
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
From
Michael Paquier
Date:
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