BUG #12819: CREATE TYPE fails within CREATE SCHEMA - Mailing list pgsql-bugs

From postgresql.org@ciotog.net
Subject BUG #12819: CREATE TYPE fails within CREATE SCHEMA
Date
Msg-id 20150302165554.2546.2997@wrigleys.postgresql.org
Whole thread Raw
Responses Re: BUG #12819: CREATE TYPE fails within CREATE SCHEMA  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: BUG #12819: CREATE TYPE fails within CREATE SCHEMA  (John R Pierce <pierce@hogranch.com>)
List pgsql-bugs
The following bug has been logged on the website:

Bug reference:      12819
Logged by:          Chris Craig
Email address:      postgresql.org@ciotog.net
PostgreSQL version: 9.3.5
Operating system:   Ubuntu 14.04.1 LTS
Description:

When creating objects within a CREATE SCHEMA definition, "CREATE TYPE" fails
with 'ERROR:  syntax error at or near "TYPE"'.

Eg:
postgres=# CREATE SCHEMA foo
postgres-# CREATE TYPE foo.bar AS ENUM('ONE','TWO','THREE');
ERROR:  syntax error at or near "TYPE"
LINE 2: CREATE TYPE foo.bar AS ENUM('ONE','TWO','THREE');
               ^

pgsql-bugs by date:

Previous
From: Kevin Grittner
Date:
Subject: Re: BUG #12810: database conection drop
Next
From: Tom Lane
Date:
Subject: Re: BUG #12819: CREATE TYPE fails within CREATE SCHEMA