"Marc G. Fournier" <[EMAIL PROTECTED]> 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

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Reply via email to