Re: Simplify pg_collation.collversion for Windows libc - Mailing list pgsql-hackers

From Thomas Munro
Subject Re: Simplify pg_collation.collversion for Windows libc
Date
Msg-id CA+hUKGLiqGmEeSvco4c53BD_dNGQWpvE1FpSdKCLV2eFPfDp+Q@mail.gmail.com
Whole thread Raw
In response to Simplify pg_collation.collversion for Windows libc  ("Daniel Verite" <daniel@manitou-mail.org>)
Responses Re: Simplify pg_collation.collversion for Windows libc
List pgsql-hackers
On Mon, Jun 5, 2023 at 12:56 PM Daniel Verite <daniel@manitou-mail.org> wrote:
> postgres=# select collversion,count(*) from pg_collation group by
> collversion;
>   collversion  | count
> ---------------+-------
>                |     5
>  1539.5,1539.5 |  1457
> (2 rows)
>
> According to [1] the second number is obsolete, and AFAICS we should
> expose only the first.

Would it be a good idea to remove or ignore the trailing /,*$/
somewhere, perhaps during pg_upgrade, to avoid bogus version mismatch
warnings?



pgsql-hackers by date:

Previous
From: Peter Geoghegan
Date:
Subject: Re: Let's make PostgreSQL multi-threaded
Next
From: Tatsuo Ishii
Date:
Subject: Re: Let's make PostgreSQL multi-threaded