Re: Matching indexes on int8 columns? - Mailing list pgsql-admin

From Andrew Sullivan
Subject Re: Matching indexes on int8 columns?
Date
Msg-id 20031030210036.GA3749@libertyrms.info
Whole thread Raw
In response to Matching indexes on int8 columns?  (Andrew Biagioni <andrew.biagioni@e-greek.net>)
List pgsql-admin
On Wed, Oct 29, 2003 at 02:08:03PM -0500, Andrew Biagioni wrote:
>
> So finally, my question.  Why is this behavior present?  Is it actually
>   a feature that I don't know enough to appreciate?

It's the side-effect of some other features in the system.  If you
search on -hackers archives you'll find several attempts to find  a
solution to this little problem; all of them have failed so far,
AFAIK.  There was talk of making the int4-to-int8 case behave more
reasonably in 7.4, but I don't know whether it's been done.

A

--
----
Andrew Sullivan                         204-4141 Yonge Street
Afilias Canada                        Toronto, Ontario Canada
<andrew@libertyrms.info>                              M2P 2A8
                                         +1 416 646 3304 x110


pgsql-admin by date:

Previous
From: Pedro Miguel Guedes
Date:
Subject: help from Portugal
Next
From: Rajesh Kumar Mallah
Date:
Subject: Logging query durations into another table in PostgreSQL 7.4