Syntax supplements for SET options

Поиск
Список
Период
Сортировка
От Takahiro Itagaki
Тема Syntax supplements for SET options
Дата
Msg-id 20100125111623.9150.52131E4D@oss.ntt.co.jp
обсуждение исходный текст
Ответы Re: Syntax supplements for SET options  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
I found a couple of incomplete syntax when I was adjusting psql
automatic tab completion for HEAD.

1. We cannot specify tablespace options on "CREATE TABLESPACE"  though "ALTER TABLESPACE" supports generic options by
SET(...).
 

2. Should we still support "ALTER COLUMN SET STATISTICS"  though we can set generic options with "ALTER COLUMN SET
(...)"?
 

3. We cannot specify column options on "CREATE TABLE"  though "ALTER TABLE ALTER COLUMN SET ..." supports it.

Which item should we fix?

I think the 1st is simple to be fixed if needed.
Since the 2nd was added during alpha, we could revert it if needed.
The 3rd is relatively hard to fix because we need to adjust the syntax all
of the kinds of columns options - STATISTICS, STORAGE, and generic options -
without keywords confliction.

Regards,
---
Takahiro Itagaki
NTT Open Source Software Center



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Simon Riggs
Дата:
Сообщение: Re: default_language
Следующее
От: KaiGai Kohei
Дата:
Сообщение: Re: [BUG?] strange behavior in ALTER TABLE ... RENAME TO on inherited columns