On Wed, Mar 21, 2012 at 2:56 PM, Alexander Reichstadt <lxr(at)mac(dot)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