Re: pgsql: Add hooks for session start and session end - Mailing list pgsql-hackers

From Fabrízio de Royes Mello
Subject Re: pgsql: Add hooks for session start and session end
Date
Msg-id CAFcNs+oOevy-ghcswRU2Rd5wWWaMV0kYAo9Xhp3M-HuKXPgmFg@mail.gmail.com
Whole thread Raw
Responses Re: pgsql: Add hooks for session start and session end  (Fabrízio de Royes Mello <fabriziomello@gmail.com>)
List pgsql-hackers


On Wed, Nov 15, 2017 at 11:26 PM, Andrew Dunstan <andrew.dunstan@2ndquadrant.com> wrote:
>
>
> On 11/15/2017 05:07 PM, Michael Paquier wrote:
> > On Thu, Nov 16, 2017 at 6:53 AM, Andrew Dunstan
> > <andrew.dunstan@2ndquadrant.com> wrote:
> >> On 11/15/2017 04:30 PM, Tom Lane wrote:
> >>> Andrew Dunstan <andrew.dunstan@2ndquadrant.com> writes:
> >>>> On 11/15/2017 02:17 PM, Andrew Dunstan wrote:
> >>>>> Yeah, that was my first instinct. But then how do the test_rls_hooks
> >>>>> tests succeed? They too have a shared_preload_library.
> >>>> Aha, it does
> >>>>     LOAD 'test_rls_hooks';
> >>>> at the start of its script. Of course we can't do that here.
> >>>> Not sure what the best way to resolve this is. For now I'm inclined just
> >>>> to override the installcheck target in the module's makefile and disable
> >>>> it in vcregress.pl.
> >>> Yeah.
> >>>
> >>>> Maybe we need to shift from installcheck to check mode for these
> >>>> modules. That would involve a buildfarm script change.
> >>> Seems like expending an awful lot of cycles in support of a rather trivial
> >>> feature.
> >> Possibly. At any rate I'm not going to do it immediately.
> > So why not just nuking it from the core code? The test module is
> > basically dead code now, and has been useful during review to check
> > that the positions of the hooks are adapted to run SQL queries at
> > session start and end. I don't mind to include it in my own set of
> > plugins on github instead.
>
>
> It's not dead at all. "make check" works just fine. It would be possible
> to create a trivial buildfarm module to run that if we wanted to.
>

Hi Mr.,

Sorry for disturbing you, but the patch status was changed for "Waiting on author" [1]. It's an accidental change?

pgsql-hackers by date:

Previous
From: Serge Rielau
Date:
Subject: Re: Treating work_mem as a shared resource (Was: Parallel Hashtake II)
Next
From: Pavel Stehule
Date:
Subject: Re: pspg - psql pager