Re: pg18: Virtual generated columns are not (yet) safe when superuser selects from them

Поиск
Список
Период
Сортировка
От Feike Steenbergen
Тема Re: pg18: Virtual generated columns are not (yet) safe when superuser selects from them
Дата
Msg-id CAK_s-G1tePk2GyjQBmb3T9MnwMuiyOcjpmDprKAdmm04qmGOKw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: pg18: Virtual generated columns are not (yet) safe when superuser selects from them  (Robert Haas <robertmhaas@gmail.com>)
Ответы Re: pg18: Virtual generated columns are not (yet) safe when superuser selects from them
Список pgsql-hackers
On Thu, 29 May 2025 at 15:43, Robert Haas <robertmhaas@gmail.com> wrote:
> that would also imply,
> for example, that there's no way to run a pg_dump without letting any
> user on the system obtain superuser privileges.

I checked, pg_dump seems safe, it doesn't extract the values, even when
using --column-inserts.

pg_restore may have issues though, as it will run these functions
for GENERATED STORED columns?

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