I re-installed postgresql as a service and CREATE TYPE AS works. So I then
re-installed postgresql as a program (as I had originally done) and CREATE
TYPE AS doesn't work.
Perhaps you could check this on your system.
John Smith
------------------------------------------------------
>From: Michael Fuhr <mike@fuhr.org>
>Reply-To: pgsql-bugs@postgresql.org
>To: John Smith <johnsmit89@hotmail.com>
>CC: pgsql-bugs@postgresql.org
>Subject: Re: [BUGS] BUG #1547: CREATE TYPE AS error
>Date: Tue, 22 Mar 2005 20:07:13 -0700
>
>On Tue, Mar 22, 2005 at 11:05:46PM +0000, John Smith wrote:
> > In my haste to write the email I didn't notice the spelling mistake.
> > However in postgres I did spell
> > CREATE coreectly. I am using the Windows 2000 os and the windows native
> > version of PostgresQL 8.0.1. I tried this command in psql and pgaccess.
> > Both return the same error - parser error at or near "as". Also I
>realised
> > later the type I was trying to create was a composite, not complex as I
> > wrote.
>
>Please copy and paste the exact command you're running and the exact
>error message. It's important to copy the actual command and error
>rather than type what you *think* they are because minor differences
>can sometimes matter.
>
>The following works for me in PostgreSQL 8.0.1:
>
>CREATE TYPE product AS (name varchar, price numeric);
>
>--
>Michael Fuhr
>http://www.fuhr.org/~mfuhr/