Re: Matching indexes on int8 columns?

From: Andrew Sullivan <andrew(at)libertyrms(dot)info>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Matching indexes on int8 columns?
Date: 2003-10-30 21:00:37
Message-ID: 20031030210036.GA3749@libertyrms.info
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)libertyrms(dot)info> M2P 2A8
+1 416 646 3304 x110

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Nathan Scott 2003-10-30 22:12:21 Re: [linux-lvm] RE: [PERFORM] backup/restore - another ar ea.
Previous Message David Wagoner 2003-10-30 19:36:21 Re: PostgreSQL Metadata