Re: Dubious usage of TYPCATEGORY_STRING - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: Dubious usage of TYPCATEGORY_STRING
Date
Msg-id 7f0de634-5f0c-315f-80cf-d1218cdc1cf2@enterprisedb.com
Whole thread Raw
In response to Dubious usage of TYPCATEGORY_STRING  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Dubious usage of TYPCATEGORY_STRING  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On 02.12.21 22:22, Tom Lane wrote:
> My first thought about fixing point 1 was to put "char" into some
> other typcategory, but that turns out to break some of psql's
> catalog queries, with results like:
> 
> regression=# \dp
> ERROR:  operator is not unique: unknown || "char"
> LINE 16:            E' (' || polcmd || E'):'
>                            ^
> HINT:  Could not choose a best candidate operator. You might need to add explicit type casts.

Could we add explicit casts (like polcmd::text) here?  Or would it break 
too much?




pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Is there any documentation on how to correctly create extensions in HA(primary-standby) setup?
Next
From: Tom Lane
Date:
Subject: Re: Dubious usage of TYPCATEGORY_STRING