[pgpool-general: 7031] Re: Suggestion on column cast automatically to data type
Tatsuo Ishii
ishii at sraoss.co.jp
Fri May 22 08:21:31 JST 2020
[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.
More information about the pgpool-general
mailing list