[geeklog-devel] MS SQL question: ALTER TABLE

[Dirk Haun]

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/