[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-admin
Subject:    Re: [ADMIN] Matching indexes on int8 columns?
From:       Andrew Sullivan <andrew () libertyrms ! info>
Date:       2003-10-30 21:00:37
[Download RAW message or body]

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


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
[prev in list] [next in list] [prev in thread] [next in thread]