* Martin Edenhofer > I need to change the data type of the article.a_message_id from > varchar(250) to varchar(1000). > >> ALTER TABLE article ALTER COLUMN article SET varchar(1000); > > is not working, because I think it's not (easy) possible to > change the data type in postgrsql. > > What is the syntax for postgresql? > > Thanks for your help!
You might want to see http://thread.gmane.org/gmane.comp.otrs.devel/530. Essentially, you'll have to do something like this: ALTER TABLE article ADD COLUMN a_message_id_new varchar(1000); UPDATE article SET a_message_id_new = a_message_id; ALTER TABLE article DROP COLUMN a_message_id; ALTER TABLE article RENAME COLUMN a_message_id_new TO a_message_id; And then add any necessary default values and keys/constraints to the new column. If this is on a live system, you'll have to lock the table as well, but you can probably do the ADD COLUMN outside the lock. If you want to disturb the live system as little as possible, you probably want to see if renaming the column a_message_id to a_message_id_old is faster than dropping it, and if so do just that inside the transaction and then drop it afterwards. Arne. _______________________________________________ OTRS mailing list: dev - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/dev To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/dev
