"sandhya" <sandhyar@amiindia.co.in> writes:
> When i am tring to change the column type from character/Varchar to =
> "int" i am getting error like,
> ERROR: column "fname" cannot be cast to type "int4"
If this is a pre-8.0 PG version, try casting to text and then int4.
If 8.0 or later, it should work as is --- would you show us exactly
what you did?
regards, tom lane