[geeklog-devel] MS SQL question: ALTER TABLE

Dirk Haun dirk at haun-online.de
Sat Sep 19 12:04:12 EDT 2009

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


More information about the geeklog-devel mailing list