Re: BUG #12819: CREATE TYPE fails within CREATE SCHEMA

From: Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #12819: CREATE TYPE fails within CREATE SCHEMA
Date: 2015-03-02 22:42:50
Message-ID: 8761aj2ffu.fsf@news-spur.riddles.org.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

>>>>> "Tom" == Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> writes:

Tom> Currently, only CREATE TABLE, CREATE VIEW, CREATE INDEX, CREATE
Tom> SEQUENCE, CREATE TRIGGER and GRANT are accepted as clauses within
Tom> CREATE SCHEMA.

Tom> That's basically driven by what was required in SQL92. It's
Tom> unlikely that we're going to worry about extending that set much,
Tom> because the lack of separating semicolons means that we risk
Tom> syntax ambiguities anytime we add more options.

CREATE and GRANT are both fully reserved already; what potential
ambiguities are introduced by adding more CREATE statement variants to
that list? (all the spec's clauses for the body of CREATE SCHEMA begin
with either CREATE or GRANT)

--
Andrew (irc:RhodiumToad)

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message nlp.sr 2015-03-03 00:57:19 BUG #12821: Cannot install xlogdump
Previous Message Kevin Grittner 2015-03-02 20:55:13 Re: BUG #12816: Problem in usung psql