Re: [PHP-DB] change datatype in postgres

2003-07-24 Thread Norma Ramirez - TECNOSOFT
Thank´s Xaos, help´s a lot. = Regards, Norma R -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] change datatype in postgres

2003-07-23 Thread Norma Ramirez - TECNOSOFT
Thank´s Xaos, but I have a inocent question ¿why on earth can`t do with a simple alter table like other databases??? and, o.k drop the old column buy copy the data into a new one? how? with an update query? Thank´s again and sorry if bother =) -- PHP Database Mailing List

Re: [PHP-DB] change datatype in postgres

2003-07-23 Thread Xaos
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Postgresql doesn't support altering the size or data type of a table field. Prolly the quickest way for you to fix this table is to create another table the way you want it, with the same fieldnames, but the size you wanted and do COPY old_tablename