Re: [HACKERS] proposal: session server side variables

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


2017-01-04 14:33 GMT+01:00 Fabien COELHO <coelho@cri.ensmp.fr>:

An alternative is to implement sub (nested) transactions, like Oracle and MS SQL Server... but that would be quite some work.

As a complement, a search showed that IBM DB2, cited as a reference by Pavel, has AUTONOMOUS transactions, which looks pretty much the same thing as nested transactions. The documentation presents an interesting use security-related use case:

I had on my mind autonomous transactions.
 

https://www.ibm.com/developerworks/data/library/techarticle/dm-0907autonomoustransactions/

The idea is that an application must record an attempt to access a data even if the attempt fails and is rolled-back.

Now we can this feature emulate with dblink, and there are patches in commitfest based on background workers, and emulation will be cheaper.

Regards

Pavel 

This feature used carefully within an appropriate pattern would allow to ensure that if the setup transaction fails then the session status is FALSE. One possible inconsistency which may arise with sub xacts is that the status may stay FALSE while the setup has succeeded, however this on the safe side wrt to the security use case. 


--
Fabien.

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

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: [HACKERS] pg_sequence catalog
Следующее
От: Robert Haas
Дата:
Сообщение: Re: [HACKERS] increasing the default WAL segment size