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

Поиск
Список
Период
Сортировка
Искать
От
Laurenz Albe
Тема
Re: Prevent writes on large objects in read-only transactions
Дата
в 12:02:24
Msg-id
fa456f80854a60819111518f187c5c446bf3e31e.camel@cybertec.at
Ответ на
Prevent writes on large objects in read-only transactions (Yugo NAGATA)
Список
Дерево обсуждения
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 Laurenz Albe <laurenz.albe@cybertec.at>
Re: Prevent writes on large objects in read-only transactions Michael Paquier <michael@paquier.xyz>
Re: Prevent writes on large objects in read-only transactions Michael Paquier <michael@paquier.xyz>
Re: 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>
Re: Prevent writes on large objects in read-only transactions Robert Haas <robertmhaas@gmail.com>
Re: Prevent writes on large objects in read-only transactions Tom Lane <tgl@sss.pgh.pa.us>
Re: Prevent writes on large objects in read-only transactions Robert Haas <robertmhaas@gmail.com>
Re: Prevent writes on large objects in read-only transactions Michael Paquier <michael@paquier.xyz>
Re: Prevent writes on large objects in read-only transactions Robert Haas <robertmhaas@gmail.com>
Re: Prevent writes on large objects in read-only transactions Tom Lane <tgl@sss.pgh.pa.us>
Re: Prevent writes on large objects in read-only transactions Michael Paquier <michael@paquier.xyz>
Re: 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>
Re: 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>
Re: Prevent writes on large objects in read-only transactions Yugo NAGATA <nagata@sraoss.co.jp> 
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
Дата:
Следующее
От: Peter Eisentraut
Дата:
FAQ