Skip site navigation (1) Skip section navigation (2)

Re: BUG #1547: CREATE TYPE AS error

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: John Smith <johnsmit89(at)hotmail(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #1547: CREATE TYPE AS error
Date: 2005-03-18 05:41:09
Message-ID: 20050318054109.GA14340@winnie.fuhr.org (view raw or flat)
Thread:
Lists: 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/

In response to

Responses

pgsql-bugs by date

Next:From: Michael FuhrDate: 2005-03-18 06:02:50
Subject: Re: BUG #1551: You need an import/export feature
Previous:From: BobbyDate: 2005-03-17 20:24:06
Subject: BUG #1551: You need an import/export feature

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group