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

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: ALTER TABLE SET (toast.asdf) is not rejected
Дата
Msg-id 20180611154759.rk4df3wuaovq3b4u@alvherre.pgsql
обсуждение исходный текст
Ответ на ALTER TABLE SET (toast.asdf) is not rejected  (Justin Pryzby <pryzby@telsasoft.com>)
Ответы Re: ALTER TABLE SET (toast.asdf) is not rejected ... if a table hasno toast
Список 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 по дате отправления:

Предыдущее
От: Justin Pryzby
Дата:
Сообщение: ALTER TABLE SET (toast.asdf) is not rejected
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: Fwd: Add to watchdog cluster request is rejected by node