I just found a thread that outlines this issue and how to solve it here: <http://archives.postgresql.org/pgsql-general/2005-12/msg01322.php>
Thanks Alex Am 21.03.2012 um 20:56 schrieb Alexander Reichstadt: > 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
