Re: %Alter Help

To start off with, I would say it's that "ALTER TABLE" statement first.

I believe, as Michael said, it should be

ALTER COLUMN lugar.sitio TYPE varchar2(500)
Or ALTER COLUMN lugar.sitio TYPE varchar(500)

Andy

> -----Original Message-----
> From: pgsql-admin-owner(at)postgresql(dot)org [mailto:pgsql-admin-
> owner(at)postgresql(dot)org] On Behalf Of Michael Fuhr
> Sent: 11 July 2006 12:58 am
> To: KyLiE
> Cc: pgsql-admin(at)postgresql(dot)org
> Subject: Re: [ADMIN] %Alter Help
>
> On Mon, Jul 10, 2006 at 04:55:40PM -0500, KyLiE wrote:
> > Hi all, I have a new question, know i'm trying to alter one of my
> > tables,but the thing is, that I need to change the range of one of my
> > columns, I've allready try this:
> >
> > ALTER TABLE lugar alter column sitio varchar2(500);
> >
> > but it gives me a syntax error. and i don't know why.
>
> What's the exact error message and what version of PostgreSQL are
> you running? At least three things could be contributing to the
> error:
>
> 1. The syntax for altering a column's type is
>
> ALTER [ COLUMN ] column TYPE type [ USING expression ]
>
> The command you showed is missing the word "TYPE".
>
> 2. Altering a column's type is supported only in PostgreSQL 8.0 and
> later; if you're using 7.4 or earlier then you'll need to perform
> the steps shown in the FAQ:
>
> http://www.postgresql.org/docs/faqs.FAQ.html#item4.3
>
> 3. PostgreSQL doesn't have a builtin varchar2 type. Unless you've
> added varchar2 then use varchar instead.
>
> Try this:
>
> ALTER TABLE lugar ALTER COLUMN sitio TYPE varchar(500);
>
> --
> Michael Fuhr
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>
> !DSPAM:14,44b2edbc34535200862907!
>