Re: Prevent writes on large objects in read-only transactions

Поиск
Список
Период
Сортировка
От Laurenz Albe
Тема Re: Prevent writes on large objects in read-only transactions
Дата
Msg-id fa456f80854a60819111518f187c5c446bf3e31e.camel@cybertec.at
обсуждение исходный текст
Ответ на Prevent writes on large objects in read-only transactions  (Yugo NAGATA <nagata@sraoss.co.jp>)
Ответы Re: Prevent writes on large objects in read-only transactions  (Michael Paquier <michael@paquier.xyz>)
Список pgsql-hackers
Дерево обсуждения 
On Fri, 2022-05-27 at 15:30 +0900, Yugo NAGATA wrote:
> Currently, lo_creat(e), lo_import, lo_unlink, lowrite, lo_put,
> and lo_from_bytea are allowed even in read-only transactions.
> By using them, pg_largeobject and pg_largeobject_metatable can
> be modified in read-only transactions and the effect remains
> after the transaction finished. Is it unacceptable behaviours, 
> isn't it?

+1

Yours,
Laurenz Albe

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

Предыдущее
От: Thomas Munro
Дата:
Сообщение: Re: "ERROR: latch already owned" on gharial
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: allow building trusted languages without the untrusted versions