Re: ALTER TABLE SET (toast.asdf) is not rejected - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: ALTER TABLE SET (toast.asdf) is not rejected
Date
Msg-id 20180611154759.rk4df3wuaovq3b4u@alvherre.pgsql
Whole thread Raw
In response to ALTER TABLE SET (toast.asdf) is not rejected  (Justin Pryzby <pryzby@telsasoft.com>)
Responses Re: ALTER TABLE SET (toast.asdf) is not rejected ... if a table hasno toast  (Justin Pryzby <pryzby@telsasoft.com>)
List pgsql-general
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


pgsql-general by date:

Previous
From: Justin Pryzby
Date:
Subject: ALTER TABLE SET (toast.asdf) is not rejected
Next
From: Adrian Klaver
Date:
Subject: Re: Fwd: Add to watchdog cluster request is rejected by node