Re: [BUGS] ORDER BY bug in 8.1, WinXP

2006-04-08 Thread Tom Lane
Alvaro Herrera <[EMAIL PROTECTED]> writes: > I observe that Paolo was using 8.1.0 and Oswaldo 8.1.1. This appears to be the same bug already fixed in 8.1.3: 2006-01-29 12:27 tgl * src/: backend/optimizer/path/indxpath.c, backend/optimizer/path/pathkeys.c, include/optimizer/paths

[BUGS] ORDER BY bug in 8.1, WinXP

2006-04-08 Thread Alvaro Herrera
This problem was reported by Paolo Lopez in pgsql-es-ayuda. Those who can read spanish can probably get a better picture by seeing the archives there. The initial post in the thread is this one: http://archives.postgresql.org/pgsql-es-ayuda/2006-04/msg00095.php This one, by Oswaldo Hernandez, ha

Re: [BUGS] bug in windows xp

2006-04-08 Thread Tom Lane
Martijn van Oosterhout writes: > Re: SIGFPE on integer divide. > This signal does appear on linux also. Hmm, it seems to depend on the hardware you're using. I just tried it on four different machines: x86 (Pentium 4): SIGFPE x86_64 (Xeon EM64T): SIGFPE HPPA: "ERROR: integer out of range" (th

Re: [BUGS] bug in windows xp

2006-04-08 Thread Martijn van Oosterhout
Re: SIGFPE on integer divide. This signal does appear on linux also. On my 7.4.7 installation it doesn't because of some problem with the integer conversion code but on 8.2devel it gets a SIGFPE. > SELECT (-2147483648) / (-1); ERROR: floating-point exception DETAIL: An invalid floating-point op

[BUGS] BUG #2382: Fail ODBC Connection

2006-04-08 Thread Genaro Gambino
The following bug has been logged online: Bug reference: 2382 Logged by: Genaro Gambino Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0 Operating system: Windows XP, Linux Description:Fail ODBC Connection Details: I have a LINUX SERVER with POSTGRES working

Re: [BUGS] Bug in window xp

2006-04-08 Thread Magnus Hagander
> "Magnus Hagander" <[EMAIL PROTECTED]> writes: > > What we get is Integer Overflow, on the instruction "idiv > esi" in postgres!int4div+0x1f. (Per windows debugger.) Same > does not happen on Linux. > > > Tom - hints? ;-) Any idea why this happens on win32 but not linux? > > Perhaps there's so