Re: function for setting/getting same timestamp during whole transaction

Поиск
Список
Период
Сортировка
От Miroslav Šimulčík
Тема Re: function for setting/getting same timestamp during whole transaction
Дата
Msg-id CAHRNM68ifYbX8Ef4L9ueMwOEdFgekKTjO4-QEqdVV00jia6YoA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: function for setting/getting same timestamp during whole transaction  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers

I might be confused here, but I think the point is that if you pass
"true" as the third argument to set_config, the setting lasts only for
the duration of the current transaction, like SET LOCAL.  Which I
think solves your problem.

Yes, but at the end of transaction it is reset to the value it has before transaction (session level value), which can be nonempty. I wrote example about this problem lately in this thread.

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

Предыдущее
От: Pavel Stehule
Дата:
Сообщение: performance regression in 9.2 CTE with SRF function
Следующее
От: Simon Riggs
Дата:
Сообщение: Re: Considering Gerrit for CFs