Re: Toast rel options

Simon Riggs <simon@2ndQuadrant.com> writes:
> It's possible to set toast reloptions for tables that don't have toast
> tables at all. e.g. 

> create table test (c1 integer);
> ALTER TABLE test SET (toast.autovacuum_enabled = off);

> Why?

1.  Why not?

2. They might have toast tables later, after an ALTER ADD COLUMN
for instance.

3. They might have had/needed a toast table in the past.  Do
we need to make ALTER DROP COLUMN capable of flushing those
reloptions, so that they won't cause a failure at dump/reload?

I don't see any advantage whatsoever to forbidding this, and
a lot of corner cases to take care of if we did try to forbid it.
        regards, tom lane