Tom Lane wrote: > Peter Eisentraut <peter.eisentr...@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
