Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group