Horton

Re: Collation versioning

Julien Rouhaud <rjuju123@gmail.com>

View thread View on postgr.es
From: Julien Rouhaud <rjuju123@gmail.com>
To: Thomas Munro <thomas.munro@gmail.com>
Cc: Peter Eisentraut <peter.eisentraut@2ndquadrant.com>, Michael Paquier <michael@paquier.xyz>, Robert Haas <robertmhaas@gmail.com>, Laurenz Albe <laurenz.albe@cybertec.at>, Douglas Doole <dougdoole@gmail.com>, Christoph Berg <myon@debian.org>, Pg Hackers <pgsql-hackers@postgresql.org>
Date: 2020-08-13T09:52:04Z
Lists: pgsql-hackers

Attachments

On Fri, Jul 10, 2020 at 12:15:44PM +1200, Thomas Munro wrote:
> On Thu, Jul 9, 2020 at 11:13 PM Julien Rouhaud <rjuju123@gmail.com> wrote:
> > On Thu, Jul 9, 2020 at 10:00 AM Peter Eisentraut
> > <peter.eisentraut@2ndquadrant.com> wrote:
> > > In order not to derail this patch set I think it would be okay for now
> > > to just include all index AMs in dependency tracking and invent a
> > > mechanism later that excludes hash and bloom in an extensible manner.
> >
> > FTR I'll be happy to take care of that.
> 
> Ok, thanks!  Let's go with that.

Thanks!

Here's a rebased v27 that removes the current approach to ignore indexes that
don't rely on a stable ordering.  I'll start a new thread on that matter once
the infrastructure pieces will be committed.

Commits

  1. Doc: Document known problem with Windows collation versions.

  2. Add collation versions for FreeBSD.

  3. Tolerate version lookup failure for old style Windows locale names.

  4. Track collation versions for indexes.

  5. Add pg_depend.refobjversion.

  6. Remove pg_collation.collversion.

  7. Fix the MSVC build for versions 2015 and later.

  8. Add collation versions for Windows.

  9. Implement type regcollation

  10. Use libc version as a collation version on glibc systems.

  11. Make type "name" collation-aware.