Re: BUG #1547: CREATE TYPE AS error - Mailing list pgsql-bugs

From Michael Fuhr
Subject Re: BUG #1547: CREATE TYPE AS error
Date
Msg-id 20050318054109.GA14340@winnie.fuhr.org
Whole thread Raw
In response to BUG #1547: CREATE TYPE AS error  ("John Smith" <johnsmit89@hotmail.com>)
List pgsql-bugs
On Tue, Mar 15, 2005 at 05:43:15PM +0000, John Smith wrote:

> When trying to create a complex type, the parser produces an error. e.g.
>    CREAYE TYPE product AS (name varchar, price numeric);
> produces
>     ERROR: parser: parse error at or near "as"

Is that the *exact* command you're running?  The word CREATE is
misspelled, although that should give a different error:

CREAYE TYPE product AS (name varchar, price numeric);
ERROR:  syntax error at or near "CREAYE" at character 1
LINE 1: CREAYE TYPE product AS (name varchar, price numeric);
        ^

If that's not the actual command, then please copy and paste what
you're really doing.

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

pgsql-bugs by date:

Previous
From: Oliver Siegmar
Date:
Subject: Possible temp table bug in PostgreSQL 7.4.7 / 8.0.1
Next
From: Michael Fuhr
Date:
Subject: Re: BUG #1551: You need an import/export feature