Re: [PATCH][PROPOSAL] Refuse setting toast.* reloptions when TOAST table does not exist
От
Tom Lane
Тема
Re: [PATCH][PROPOSAL] Refuse setting toast.* reloptions when TOAST table does not exist
Дата
Msg-id
12731.1516897774@sss.pgh.pa.us
Ответ на
Re: [PATCH][PROPOSAL] Refuse setting toast.* reloptions when TOASTtable does not exist (Alvaro Herrera)
Список
Дерево обсуждения
[PATCH][PROPOSAL] Refuse setting toast.* reloptions when TOAST table does not exist Nikolay Shaplov <dhyan@nataraj.su>
Re: [PATCH][PROPOSAL] Refuse setting toast.* reloptions when TOASTtable does not exist Robert Haas <robertmhaas@gmail.com>
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 Nikolay Shaplov <dhyan@nataraj.su>
Re: [PATCH][PROPOSAL] Refuse setting toast.* reloptions when TOASTtable does not exist Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: [PATCH][PROPOSAL] Refuse setting toast.* reloptions when TOAST table does not exist Nikolay Shaplov <dhyan@nataraj.su>
Re: [PATCH][PROPOSAL] Refuse setting toast.* reloptions when TOASTtable does not exist Robert Haas <robertmhaas@gmail.com>
Re: [PATCH][PROPOSAL] Refuse setting toast.* reloptions when TOASTtable does not exist Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
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 TOASTtable does not exist Alvaro Herrera <alvherre@alvh.no-ip.org>
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 Nikolay Shaplov <dhyan@nataraj.su>
Re: [PATCH][PROPOSAL] Refuse setting toast.* reloptions when TOASTtable does not exist Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: [PATCH][PROPOSAL] Refuse setting toast.* reloptions when TOASTtable does not exist David Steele <david@pgmasters.net>
Re: [PATCH][PROPOSAL] Refuse setting toast.* reloptions when TOAST table does not exist Nikolay Shaplov <dhyan@nataraj.su>
Re: [PATCH][PROPOSAL] Refuse setting toast.* reloptions when TOASTtable does not exist Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: [PATCH][PROPOSAL] Refuse setting toast.* reloptions when TOASTtable does not exist David Steele <david@pgmasters.net>
Re: [PATCH][PROPOSAL] Refuse setting toast.* reloptions when TOASTtable does not exist Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Alvaro Herrera writes: > Tom Lane wrote: >> 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. That adds a lot of overhead if you never actually need the toast table. Still, maybe it's an appropriate amount of effort compared to the size of the use-case for this. regards, tom lane
В списке pgsql-hackers по дате отправления