Re: Simplify pg_collation.collversion for Windows libc

From: Thomas Munro <thomas(dot)munro(at)gmail(dot)com>
To: Daniel Verite <daniel(at)manitou-mail(dot)org>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Simplify pg_collation.collversion for Windows libc
Date: 2023-06-06 01:21:06
Message-ID: CA+hUKGLiqGmEeSvco4c53BD_dNGQWpvE1FpSdKCLV2eFPfDp+Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Mon, Jun 5, 2023 at 12:56 PM Daniel Verite <daniel(at)manitou-mail(dot)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?

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tatsuo Ishii 2023-06-06 01:30:05 Re: Let's make PostgreSQL multi-threaded
Previous Message Peter Geoghegan 2023-06-06 00:50:04 Re: Let's make PostgreSQL multi-threaded