"Marc G. Fournier" <scrappy@postgresql.org> writes:
> so, its trying bigint = int, and not picking up the index ...
> the database server is 7.4.3 ... is this something that has been made a
> bit more intelligent in 8.0? other then casting 0 to bigint, is there
> something else I should be looking at doing? Having them go through all
> of their code and casting all ints to bigint for this sounds a bit extreme
> :(
Yes, no, and no kidding ;-). We've been getting beat on for *years*
about this behavior, but it took the proverbial Good Idea to find a
workable solution. Can't generate those on a schedule I'm afraid...
regards, tom lane