Search Postgresql Archives

Re: Altering column type from text to bytea

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux