From: Michael Fuhr <mike@fuhr.org>
To: KÖPFERL Robert <robert.koepferl@sonorys.at>
Cc: 'pgsql-sql@postgresql.org' <pgsql-sql@postgresql.org>
Subject: Re: Syntax error while altering col-type
Date: Wed, 12 Jan 2005 10:17:56 -0700
Message-ID: <20050112171756.GA95208@winnie.fuhr.org> (raw)
In-Reply-To: <ED4E30DD9C43D5118DFB00508BBBA76EB16540@neptun.sonorys.at>
References: <ED4E30DD9C43D5118DFB00508BBBA76EB16540@neptun.sonorys.at>
On Wed, Jan 12, 2005 at 06:02:10PM +0100, KÖPFERL Robert wrote:
> ALTER TABLE "Mailboxes" ALTER COLUMN "Status" TYPE int4;
>
> This shuld be no problem since the current type acutally is int4 and the
> names are copy'n'pasted. The server responds as follows:
>
> ERROR: syntax error at or near "TYPE" at character 47
That's exactly the error you'd get on a pre-8.0 system that doesn't
support altering a column's type. Are you looking at 8.0 documentation
but running a 7.x server? What does "SELECT version();" show?
--
Michael Fuhr
http://www.fuhr.org/~mfuhr/
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: mike@fuhr.org, robert.koepferl@sonorys.at
Subject: Re: Syntax error while altering col-type
In-Reply-To: <20050112171756.GA95208@winnie.fuhr.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox