[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
--
http://www.geeklog.net/
http://geeklog.info/
More information about the geeklog-devel
mailing list