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

2014-05-01 Thread Michael Paquier
On Fri, May 2, 2014 at 2:06 PM, Michael Paquier
 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


-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers


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

2014-05-01 Thread Michael Paquier
On Fri, May 2, 2014 at 1:37 PM, Rajmohan C  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


-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers


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

2014-05-01 Thread Atri Sharma
On Fri, May 2, 2014 at 10:07 AM, Rajmohan C  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*