Re: [HACKERS] proposal: session server side variables - Mailing list pgsql-hackers

From Fabien COELHO
Subject Re: [HACKERS] proposal: session server side variables
Date
Msg-id alpine.DEB.2.20.1702062027180.8133@lancre
Whole thread Raw
In response to Re: [HACKERS] proposal: session server side variables  (Pavel Stehule <pavel.stehule@gmail.com>)
Responses Re: [HACKERS] proposal: session server side variables
List pgsql-hackers
Hello,

> I'll work on my proposal in v11 time. Maybe in this time Postgres will 
> support autonomous transactions.

Maybe.

> The variables syntax should be better integrated to core - it should be
> implemented without getter/setter functions.

Yes, a nicer syntax would be great.

Note that setter/getter could be useful for some use case, eg with queries 
built dynamically?

> I am not sure If statement SET can be enhanced to allows the work with 
> session variables without some conflicts, but we will see.

If so, maybe some kind of prefix could provide a workaround.

-- 
Fabien.



pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: [HACKERS] Add pgstathashindex() to get hash index table statistics.
Next
From: Peter Eisentraut
Date:
Subject: Re: [HACKERS] Active zombies at AIX