"sandhya" <sandhyar@xxxxxxxxxxxxxx> 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
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
message can get through to the mailing list cleanly
