Re: [BUGS] BUG #1547: CREATE TYPE AS error

2005-04-11 Thread Michael Fuhr
On Mon, Apr 11, 2005 at 10:54:43AM -0400, Tom Lane wrote: > Michael Fuhr <[EMAIL PROTECTED]> writes: > > 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 t

Re: [BUGS] BUG #1547: CREATE TYPE AS error

2005-04-11 Thread Tom Lane
Michael Fuhr <[EMAIL PROTECTED]> writes: > 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?). I found it just about impossible

Re: [BUGS] BUG #1547: CREATE TYPE AS error

2005-04-11 Thread Michael Fuhr
On Mon, Apr 11, 2005 at 08:21:45AM +0200, Diego Cattelan wrote: > > > >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. > > windows XP pro SP2 > PostgreSQL 8.0.1 > > this is working for me (but n

Re: [BUGS] BUG #1547: CREATE TYPE AS error

2005-04-10 Thread Diego Cattelan
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. 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);

Re: [BUGS] BUG #1547: CREATE TYPE AS error

2005-04-10 Thread Michael Fuhr
On Wed, Apr 06, 2005 at 11:55:05PM +, John Smith wrote: > > I have already told you the exact command I am using - twice. 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

Re: [BUGS] BUG #1547: CREATE TYPE AS error

2005-04-10 Thread John Smith
AIL PROTECTED]> Reply-To: pgsql-bugs@postgresql.org To: John Smith <[EMAIL PROTECTED]> CC: pgsql-bugs@postgresql.org Subject: Re: [BUGS] BUG #1547: CREATE TYPE AS error Date: Sat, 2 Apr 2005 19:23:45 -0700 On Mon, Mar 28, 2005 at 12:51:42AM +, John Smith wrote: > I re-installed po

Re: [BUGS] BUG #1547: CREATE TYPE AS error

2005-04-02 Thread Michael Fuhr
On Mon, Mar 28, 2005 at 12:51:42AM +, John Smith wrote: > 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. Can't help

Re: [BUGS] BUG #1547: CREATE TYPE AS error

2005-04-02 Thread John Smith
From: Michael Fuhr <[EMAIL PROTECTED]> Reply-To: pgsql-bugs@postgresql.org To: John Smith <[EMAIL PROTECTED]> 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 +, John Smith wrote: >

Re: [BUGS] BUG #1547: CREATE TYPE AS error

2005-03-22 Thread Michael Fuhr
On Tue, Mar 22, 2005 at 11:05:46PM +, 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 psq

Re: [BUGS] BUG #1547: CREATE TYPE AS error

2005-03-17 Thread Michael Fuhr
On Tue, Mar 15, 2005 at 05:43:15PM +, 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?

[BUGS] BUG #1547: CREATE TYPE AS error

2005-03-17 Thread John Smith
The following bug has been logged online: Bug reference: 1547 Logged by: John Smith Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0 Operating system: Windows 2000 Description:CREATE TYPE AS error Details: When trying to create a complex type, the parser pro