Peter:
So I would need to create a pg extension encapsulating this hook callback?
If this is the case, it seems it will be much more complicated than expected, and I wont be able to do it :(
But thanks for the suggestion anyway.
On Thu, Jul 25, 2019 at 12:21 PM Peter Eisentraut <peter.eisentraut@xxxxxxxxxxxxxxx> wrote:
On 2019-07-25 09:43, Cyril Champier wrote:
> It might be an interesting exercise to implement this as a post-parsing
> hook.
>
>
> I known nothing about that, but that sounds interesting, do you have any
> documentation pointer to help me implement that?
Look for post_parse_analyze_hook. Walk the parsed query tree, look for
queries without ordering clause and manufacture one.
--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
