how can i change the data type in postgres???? i have a table with foreign keys to other tables.. is there any way of changing one of its field datatype that doesnt have any foreign key constraint without effecting other constraints??? i dont want to drop the table as it will result in creating the whole database again... can anyone help me out???
-jiby
