The following bug has been logged online:

Bug reference: 1547
Logged by: John Smith
Email address: johnsmit89 (AT) hotmail (DOT) com
PostgreSQL version: 8.0
Operating system: Windows 2000
Description: CREATE TYPE AS error
Details:

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"

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

On Tue, Mar 15, 2005 at 05:43:15PM +0000, John Smith wrote:

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/

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

On Tue, Mar 22, 2005 at 11:05:46PM +0000, John Smith 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/

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

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
------------------------------------------------------



---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

On Mon, Mar 28, 2005 at 12:51:42AM +0000, John Smith wrote:

Can't help there -- none of my systems distinguish between installing
PostgreSQL as a "service" versus as a "program."

We still haven't seen the *exact* command you're running and the
*exact* error message (the command in your original message had a
typo that results in a different error than the one you posted).
Could you please post a complete set of steps that a person using
the same platform could follow to reproduce the problem? Whenever
possible, please copy and paste commands and output instead of
typing them manually, to avoid introducing mistakes that aren't
really present.

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

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

I have already told you the exact command I am using - twice. I identified
the problem in my previous email, and how to reproduce it. If you don't have
a system with Windows 2000 then find someone who does. They will then
confirm what I say.
I resent the implication in your emails that I am some stupid user who
does't know what he is doing. Insulting your users is not the best way to
increase your user base.
I have identified the problem, and how to reproduce it. I therefore will not
engage in any further communication on this matter.

Mr. Grumpy



---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

On Wed, Apr 06, 2005 at 11:55:05PM +0000, John Smith wrote:
Could you post links to the messages in the archives where you twice
identified the command? The only complete CREATE TYPE command I
see is in your original message, which you later admitted contained
a typo:

http://archives.postgresql.org/pgsql...3/msg00131.php
http://archives.postgresql.org/pgsql...3/msg00192.php

I don't see any other messages in this thread with a complete CREATE
TYPE command (except the one I posted).

I think you're referring to this message:

http://archives.postgresql.org/pgsql...4/msg00025.php

If anybody has a Windows box, could you please test this?

Whoa. Hold on there. Nowhere did I insult you or imply that you're
stupid -- I've merely asked for enough information that somebody
else could use to duplicate the problem. You yourself admitted
that your original message contained a typo, so I've just been
trying to clarify exactly what you're doing.

Just so you know, I'm not one of the PostgreSQL developers, so
PostgreSQL users aren't "my" users or "my" user base. Like many
who subscribe to these lists, I volunteer my time to help people
because it's A Nice Thing To Do, and hopefully to remove some of
that burden from the developers so they can spend more time developing.
Please consider how your remarks sound to people who really do want
to help and expect nothing in return.

That's too bad, because if a bug exists then your input might have
been useful. Can anybody else with a Windows system reproduce the
problem? The messages in the links above are said to contain enough
information to do so.

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

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

windows XP pro SP2
PostgreSQL 8.0.1

this is working for me (but not tested on win 2000 system):
CREATE TYPE product AS (name varchar, price numeric);


---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

On Mon, Apr 11, 2005 at 08:21:45AM +0200, Diego Cattelan wrote:
In the following message, the OP says that CREATE TYPE works if he
installs PostgreSQL as a service but it doesn't work if he installs
PostgreSQL as a program (can anybody think of why this would make
a difference?).

http://archives.postgresql.org/pgsql...4/msg00025.php

Did you test both scenarios? If not, could you do so? Thanks.

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

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Michael Fuhr <mike (AT) fuhr (DOT) org> writes:
I found it just about impossible to believe ;-)

I have seen people make such reports because they mistakenly connected
to some other server entirely while trying to test one of the two
supposedly similar installations. If the other server is of an old
version then it might not have CREATE TYPE AS, for instance.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq