Syntax supplements for SET options - Mailing list pgsql-hackers

From Takahiro Itagaki
Subject Syntax supplements for SET options
Date
Msg-id 20100125111623.9150.52131E4D@oss.ntt.co.jp
Whole thread Raw
Responses Re: Syntax supplements for SET options  (Robert Haas <robertmhaas@gmail.com>)
List 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 by date:

Previous
From: Simon Riggs
Date:
Subject: Re: default_language
Next
From: KaiGai Kohei
Date:
Subject: Re: [BUG?] strange behavior in ALTER TABLE ... RENAME TO on inherited columns