[BUGS] BUG #3938: Row-wise comparison fails

2008-02-07 Thread
The following bug has been logged online: Bug reference: 3938 Logged by: Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3 Operating system: Windows XP Description:Row-wise comparison fails Details: The row-wise compare fails in the select statement below. T

Re: [BUGS] possible bug windows setup

2008-02-07 Thread Magnus Hagander
On Wed, Feb 06, 2008 at 02:59:31PM +0100, Gevik Babakhani wrote: > I might be very wrong, but when I try to install 8.3 on Windows with NLS > options selected, no share/locale files are installed. could someone please > test or confirm this? Yes, it's broken. It seems the change in Install.pm rev

[BUGS] BUG #3939: (Possibly) no NLS in 8.3 Windows

2008-02-07 Thread Gevik Babakhani
The following bug has been logged online: Bug reference: 3939 Logged by: Gevik Babakhani Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3 Operating system: Windows XP 32bit Description:(Possibly) no NLS in 8.3 Windows Details: When installing 8.3 on Windows

Re: [BUGS] BUG #3939: (Possibly) no NLS in 8.3 Windows

2008-02-07 Thread Magnus Hagander
On Thu, Feb 07, 2008 at 09:35:35AM +, Gevik Babakhani wrote: > > The following bug has been logged online: > > Bug reference: 3939 > Logged by: Gevik Babakhani > Email address: [EMAIL PROTECTED] > PostgreSQL version: 8.3 > Operating system: Windows XP 32bit > Description:

Re: [BUGS] BUG #3938: Row-wise comparison fails

2008-02-07 Thread Alvaro Herrera
[EMAIL PROTECTED] wrote: > The row-wise compare fails in the select statement below. This works in > PostgreSQL 8.2 but fails in 8.3. Confirmed here. > SELECT * from test where (str1, str2, id) > ('a', '1', 0); The error message is: alvherre=# SELECT * from test where (str1, str2, id) > ('a',

Re: [HACKERS] [BUGS] possible bug windows setup

2008-02-07 Thread Andrew Dunstan
Magnus Hagander wrote: On Wed, Feb 06, 2008 at 02:59:31PM +0100, Gevik Babakhani wrote: I might be very wrong, but when I try to install 8.3 on Windows with NLS options selected, no share/locale files are installed. could someone please test or confirm this? Yes, it's broken. It seem

Re: [HACKERS] [BUGS] possible bug windows setup

2008-02-07 Thread Magnus Hagander
On Thu, Feb 07, 2008 at 06:12:17AM -0500, Andrew Dunstan wrote: > > > Magnus Hagander wrote: > >On Wed, Feb 06, 2008 at 02:59:31PM +0100, Gevik Babakhani wrote: > > > >>I might be very wrong, but when I try to install 8.3 on Windows with NLS > >>options selected, no share/locale files are insta

Re: [HACKERS] [BUGS] possible bug windows setup

2008-02-07 Thread Andrew Dunstan
Magnus Hagander wrote: I have a patch working for me, I've sent it over to Gevik for testing in his environment. Attached here if somebody else wants to play. Looks OK. cheers andrew ---(end of broadcast)--- TIP 4: Have you searched our

Re: [BUGS] BUG #3938: Row-wise comparison fails

2008-02-07 Thread Tom Lane
I wrote: > Weird. I suppose I broke this in the operator-family rewrite. > Will look. Sigh ... I fat-fingered some loop control logic ... Index: indxpath.c === RCS file: /cvsroot/pgsql/src/backend/optimizer/path/indxpath.c,v retriev

[BUGS] BUG #3940: 'unrecognized node type: 1718580065'

2008-02-07 Thread Vladimir Kokovic
The following bug has been logged online: Bug reference: 3940 Logged by: Vladimir Kokovic Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3.0 Operating system: Linux vladakk-kuci 2.6.22-14-generic #1 SMP Fri Feb 1 04:59:50 UTC 2008 i686 GNU/Linux Description:'u

Re: [BUGS] BUG #3940: 'unrecognized node type: 1718580065'

2008-02-07 Thread Tom Lane
"Vladimir Kokovic" <[EMAIL PROTECTED]> writes: > I don't know if this is known bug, but look in my PostgreSQL log file: > 2008-02-07 17:05:18 CET asoft vlada LOG: 0: execute : CREATE > SCHEMA asoft I suppose you're submitting these commands via PQexecParams or something else that uses new-st

Re: [BUGS] BUG #3938: Row-wise comparison fails

2008-02-07 Thread Tom Lane
Alvaro Herrera <[EMAIL PROTECTED]> writes: > alvherre=# SELECT * from test where (str1, str2, id) > ('a', '1', 0); > ERREUR: could not find member 4(25,25) of opfamily 426 > Note that if I change the order of columns, it works: Weird. I suppose I broke this in the operator-family rewrite. Will