Re: Altering column type from text to bytea

[Merlin Moncure <mmoncure@xxxxxxxxx>]

On Wed, Mar 21, 2012 at 2:56 PM, Alexander Reichstadt <lxr@xxxxxxx> 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