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

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: pg18: Virtual generated columns are not (yet) safe when superuser selects from them
Дата
Msg-id 2090377.1748542522@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: pg18: Virtual generated columns are not (yet) safe when superuser selects from them  (Feike Steenbergen <feikesteenbergen@gmail.com>)
Ответы Re: pg18: Virtual generated columns are not (yet) safe when superuser selects from them
Список pgsql-hackers
Feike Steenbergen <feikesteenbergen@gmail.com> writes:
> pg_restore may have issues though, as it will run these functions
> for GENERATED STORED columns?

pg_restore is already fairly exposed, as it will run tables' CHECK
constraints, index expressions, etc.  I don't think GENERATED STORED
makes that picture much worse.

As Robert said upthread, it would be nice to make all this more
secure.  But it'd presumably involve user-visible semantics changes
along with the performance worries I mentioned.  It's a dauntingly
large task...

            regards, tom lane



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