Re: [ADMIN] alter column type

2006-04-13 Thread Jim C. Nasby
About the only thing you need to consider is that changing the type of a column will re-write the entire table, and I'm pretty sure it will hold an exclusive lock during that process. On Mon, Apr 10, 2006 at 03:13:38PM +0530, sandhya wrote: > Hi.. > If i want to change the datatype of a column i

[ADMIN] alter column type

2006-04-10 Thread sandhya
Hi..   If i want to change the datatype of a column in a table.What are all the thigs i need to take care off. After somany records insertion if i change the datatype of the column..What will be the effect of it. Please tell me /give suggestion what needs to be cosider at the time of chan