| From: | Michael Fuhr <mike(at)fuhr(dot)org> |
|---|---|
| To: | KÖPFERL Robert <robert(dot)koepferl(at)sonorys(dot)at> |
| Cc: | "'pgsql-sql(at)postgresql(dot)org'" <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: Syntax error while altering col-type |
| Date: | 2005-01-12 17:17:56 |
| Message-ID: | 20050112171756.GA95208@winnie.fuhr.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
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/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2005-01-12 17:20:50 | Re: failed to find conversion function from "unknown" to text |
| Previous Message | Michael Fuhr | 2005-01-12 17:11:21 | Re: Problems with HAVING |