Hi,

when trying to change a text column to bytea I am getting the following error:
SQL error:

ERROR:  column "comment" cannot be cast to type bytea

In statement:
ALTER TABLE "public"."persons" ALTER COLUMN "comment" TYPE bytea


I found that others had the same issue but I found no solution for it. I made a 
test-table and though it was empty meaning the column of concern had only NULL 
values I got the same error when trying to change that text column to type 
bytea.

Is it possible to change column types later on to bytea?

Thanks
Alex

Reply via email to