Re: ALTER TABLE SET (toast.asdf) is not rejected

On 2018-Jun-11, Justin Pryzby wrote:

> I noticed that this is accepted:
>
> postgres=# ALTER TABLE t SET (toast.asdf=128);
> ALTER TABLE
>
> I thought since "toast" was a core namespace, it would've been rejected?
>
> I recall having read a discussion about verifying these ... I wasn't able
> to find what I was thinking of, but found this one.
> https://www.postgresql.org/message-id/flat/20090114144332.GF24156%40alvh.no-ip.org

Uh. ISTM that this was lost during the 9.4 cycle, because that command *is*
rejected in 9.3.

alvherre=# ALTER TABLE t SET (toast.asdf=128);
ERROR: unrecognized parameter "asdf"

but 9.4 takes it. Weird.

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