Postgres Pro
Downloads
Home   >   mailing lists

Thread: Altering column type from text to bytea

Altering column type from text to bytea

From
Alexander Reichstadt
Date:
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

Re: Altering column type from text to bytea

From
Alexander Reichstadt
Date:
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:

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

Re: Altering column type from text to bytea

From
Merlin Moncure
Date:
On Wed, Mar 21, 2012 at 2:56 PM, Alexander Reichstadt <lxr@mac.com> 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 "comment" TYPE bytea


TRY ALTER TYPE ...USING using either direct cast or encode() function.

Please don't post emails in HTML format, thanks!

merlin