Re: [PATCH][PROPOSAL] Refuse setting toast.* reloptions when TOASTtable does not exist

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: [PATCH][PROPOSAL] Refuse setting toast.* reloptions when TOASTtable does not exist
Дата
Msg-id 20180125155519.gmafmdoh76nriazf@alvherre.pgsql
обсуждение исходный текст
Ответ на Re: [PATCH][PROPOSAL] Refuse setting toast.* reloptions when TOAST table does not exist  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: [PATCH][PROPOSAL] Refuse setting toast.* reloptions when TOAST table does not exist
Список pgsql-hackers
Tom Lane wrote:
> Peter Eisentraut <peter.eisentraut@2ndquadrant.com> writes:
> > On 1/23/18 13:39, Robert Haas wrote:
> >> I don't understand.  AAUI, it is currently the case that if you set
> >> the options before the TOAST table exists, they are lost.
> 
> > Well, that's also weird.
> 
> Well, maybe the right answer is to address that.  It's clear to me
> why that would happen if we store these things as reloptions on the
> toast table, but can't they be stored on the parent table?

Actually, Nikolay provided a possible solution: if you execute ALTER
TABLE SET (toast.foobar = xyz), and a toast table doesn't exist, create
one at that point.

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services


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

Предыдущее
От: Konstantin Knizhnik
Дата:
Сообщение: Re: JIT compiling with LLVM v9.0
Следующее
От: "David G. Johnston"
Дата:
Сообщение: CONSTANT/NOT NULL/initializer properties for plpgsql record variables