From: | "John Smith" <johnsmit89(at)hotmail(dot)com> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: BUG #1547: CREATE TYPE AS error |
Date: | 2005-03-28 00:51:42 |
Message-ID: | BAY102-F11A342545FB6FA5F1B25CCCE440@phx.gbl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
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(at)fuhr(dot)org>
>Reply-To: pgsql-bugs(at)postgresql(dot)org
>To: John Smith <johnsmit89(at)hotmail(dot)com>
>CC: pgsql-bugs(at)postgresql(dot)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/
From | Date | Subject | |
---|---|---|---|
Next Message | Cade Cairns | 2005-03-28 04:34:34 | Re: BUG #1558: memory leak in libpq connectDBStart() |
Previous Message | Magnus Hagander | 2005-03-27 18:13:11 | Re: BUG #1560: Service does not start |