Re: Collation order for btree-indexable datatypes

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Collation order for btree-indexable datatypes
Date: 2001-05-02 23:05:49
Message-ID: Pine.BSF.4.21.0105021603260.50100-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Wed, 2 May 2001, Tom Lane wrote:

> Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> writes:
> > What parts of the changes would require an initdb, would new
> > functions need to be added or the index ops need to change or would
> > it be fixes to the existing functions (if the latter, wouldn't a recompile
> > and dropping/recreating the indexes be enough?)
>
> Yes, dropping and recreating any user indexes that contain the problematic
> values would be sufficient to get you out of trouble. We don't need any
> system catalog changes for this, AFAICS.

Looking back, I misread the original message. I thought you were saying
that it needed to wait for an initdb and so would be bad in a dot release,
but it was just the breaking of indexes thing, but since they're already
pretty broken, I don't see much of a loss by fixing it.

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Alfred Perlstein 2001-05-02 23:06:02 Re: New Linux xfs/reiser file systems
Previous Message Tom Lane 2001-05-02 23:02:28 Re: Collation order for btree-indexable datatypes