[geeklog-devel] MS SQL question: ALTER TABLE
yankees26an at gmail.com
Sat Sep 19 19:49:02 EDT 2009
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
> geeklog-devel mailing list
> geeklog-devel at lists.geeklog.net
More information about the geeklog-devel