Postgres Pro
Downloads
Home   >   mailing lists

Altering column type from text to bytea - Mailing list pgsql-general

From Alexander Reichstadt
Subject Altering column type from text to bytea
Date
Msg-id F66DF446-94A9-4FA4-B62A-20A7F10D648F@mac.com
Whole thread Raw
Responses Re: Altering column type from text to bytea  (Alexander Reichstadt <lxr@mac.com>)
Re: Altering column type from text to bytea  (Merlin Moncure <mmoncure@gmail.com>)
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: Robert Haas
Date:
Subject: Re: [BUGS] Altering a table with a rowtype column
Next
From: Alexander Reichstadt
Date:
Subject: Re: Altering column type from text to bytea