[pgpool-general: 7031] Re: Suggestion on column cast automatically to data type

[Tatsuo Ishii]

[Drop Cc: to pgsql-admin at postgresql.org]

Your question is not related to Pgpool-II. Please send such that SQL
questions to pgsql-general mailing list.

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp

From: postgann2020 s <postgann2020 at gmail.com>
Subject: [pgpool-general: 7030] Suggestion on column cast automatically to data type
Date: Thu, 21 May 2020 20:07:30 +0530
Message-ID: <CANynezOJUq=7E_4+s9p4p8qHxi=-2APtijgsNZWUYXGXw+nP5Q at mail.gmail.com>

> Hi Team,
> Thanks for your support.
> 
> Could you please suggest on below query.
> 
> We are trying to changing the data type of the column, but for every time
> triggering "column "parental_path" cannot be cast automatically to type
> tsvector".
> 
> ALTER TABLE SCHEMA.TABLE ALTER COLUMN COLUMN_NAME  TYPE tsvector;
> 
> ERROR:  column "parental_path" cannot be cast automatically to type tsvector
> HINT:  You might need to specify "USING parental_path::tsvector".
> 
> Q). Are we have any automatically changing mechanism for this type of
> conversion?.
> 
>>>>>>>>>>>>>>
> 
> Even after changing, getting below error.
> 
> ALTER TABLE SCHEMA.TABLE ALTER COLUMN COLUMN_NAME  TYPE tsvector;
> ERROR:  word is too long (2087 bytes, max 2046 bytes)
> 
> Q)Suggest, how to avoid these situations?.
> 
> Thanks for your support.
> 
> Regards,
> PostgAnn.