Horton

Re: Dubious usage of TYPCATEGORY_STRING

Peter Eisentraut <peter.eisentraut@enterprisedb.com>

View thread View on postgr.es
From: Peter Eisentraut <peter.eisentraut@enterprisedb.com>
To: Tom Lane <tgl@sss.pgh.pa.us>, pgsql-hackers@lists.postgresql.org
Date: 2021-12-07T15:48:21Z
Lists: 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?

Commits

  1. Create a new type category for "internal use" types.