Re: Dubious usage of TYPCATEGORY_STRING

From: Peter Eisentraut <peter(dot)eisentraut(at)enterprisedb(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: Dubious usage of TYPCATEGORY_STRING
Date: 2021-12-07 15:48:21
Message-ID: 7f0de634-5f0c-315f-80cf-d1218cdc1cf2@enterprisedb.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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?

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2021-12-07 15:51:46 Re: Dubious usage of TYPCATEGORY_STRING
Previous Message Peter Eisentraut 2021-12-07 15:45:55 Re: Is there any documentation on how to correctly create extensions in HA(primary-standby) setup?