Re: knngist patch support

Robert Haas <robertmhaas@gmail.com>

From: Robert Haas <robertmhaas@gmail.com>

To: Tom Lane <tgl@sss.pgh.pa.us>

Cc: Oleg Bartunov <oleg@sai.msu.su>, tomas@tuxteam.de, Teodor Sigaev <teodor@sigaev.ru>, "Ragi Y. Burhum" <rburhum@gmail.com>, Pgsql Hackers <pgsql-hackers@postgresql.org>

Date: 2010-02-13T03:18:38Z

Lists: pgsql-hackers

On Fri, Feb 12, 2010 at 10:10 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Robert Haas <robertmhaas@gmail.com> writes:
>> OK, here's another idea.  Let's just add a new column to pg_amop
>> called amoporderstrategy.  If an operator can only be used for one
>> purpose or the other, we'll set the other value to -1.
>
> ... problem for unique index, no?

Dang.  What a pain in the tail.  I guess we could make that column
nullable, but that's got it's own fair share of problems.

Is the only reasonable way to solve this problem a new catalog?
That's not tremendously scalable, but it's starting to feel like the
only way of solving this problem that doesn't involve massive surgery.

...Robert