Re: [HACKERS] proposal: session server side variables

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: [HACKERS] proposal: session server side variables
Дата
Msg-id CAFj8pRAOnk41q0cbtrDJeRWVvRiN-i+4KgXo28TVaqiJjc5-Jg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [HACKERS] proposal: session server side variables  (Fabien COELHO <coelho@cri.ensmp.fr>)
Список pgsql-hackers


2017-02-06 21:36 GMT+01:00 Fabien COELHO <coelho@cri.ensmp.fr>:

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?

There is not any problem for usage in dynamic sql. Some generic access  is done already. 
 


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.

any other database objects has not prefix. But we can identify a ambiguous situation and in this case we can require qualified identifier. 

Regards

Pavel
   


--
Fabien.

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Bernd Helmle
Дата:
Сообщение: Re: [HACKERS] LWLock optimization for multicore Power machines
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [HACKERS] Active zombies at AIX