[geeklog-devel] MS SQL question: ALTER TABLE

[ṨϮⱥȵίṥʟɑ√]

Works with pgSQL, but the syntax is a bit different. You have to add TYPE.

ALTER TABLE gl_polltopics  ALTER COLUMN [pid] TYPE VARCHAR(40);


On Sat, Sep 19, 2009 at 12:04 PM, Dirk Haun <dirk at haun-online.de> wrote:
> When upgrading from Geeklog 1.5.2 to 1.6.0, the Polls plugin was
> supposed to extend its 'pid' field to 40 characters (from 20). Due to a
> mixup of plugin version numbers, that upgrade step was not performed,
> though. I fixed that for 1.6.1 now.
>
> Now the question: MySQL doesn't care if I do an ALTER TABLE and "change"
> the field to what it already is. What about MS SQL? Oh, and Postgres?
>
> In other words: 'pid' is already a VARCHARS(40). What happens when I ask
> MS SQL to perform a
>
>    ALTER TABLE gl_polltopics ALTER COLUMN [pid] VARCHARS(40)
>
> bye, Dirk
>
>
> --
> http://www.geeklog.net/
> http://geeklog.info/
>
> _______________________________________________
> geeklog-devel mailing list
> geeklog-devel at lists.geeklog.net
> http://eight.pairlist.net/mailman/listinfo/geeklog-devel
>



-- 
Warmly,

Stanislav