Re: [GENERAL] Altering column type from text to bytea

On Wed, Mar 21, 2012 at 2:56 PM, Alexander Reichstadt wrote: > 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 "c

Re: [GENERAL] Altering column type from text to bytea

I just found a thread that outlines this issue and how to solve it here: 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

[GENERAL] Altering column type from text to bytea

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