[BUGS] BUG #3462: pg_ctl error output cannot be redirected

2007-07-18 Thread Eugene Gershnik
The following bug has been logged online: Bug reference: 3462 Logged by: Eugene Gershnik Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.4 Operating system: Windows Description:pg_ctl error output cannot be redirected Details: On Windows an attempt to do p

[BUGS] BUG #3467: Sum strange behaviour

2007-07-18 Thread Alex
The following bug has been logged online: Bug reference: 3467 Logged by: Alex Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.4 Operating system: FreeBSD 6.2-RELEASE-p4 Description:Sum strange behaviour Details: I have a database with some float numbers (al

Re: [BUGS] BUG #3467: Sum strange behaviour

2007-07-18 Thread Heikki Linnakangas
Alex wrote: > I have a database with some float numbers (all of them are 2 digits > presision). When I do select sum() I get this: 96.31001 > ... > Is this bug or future ? A feature. Floating point numbers can't generally represent a decimal number exactly, so you get some rounding errors

[BUGS] BUG #3469: SELECT QRY

2007-07-18 Thread SRIDHARAN
The following bug has been logged online: Bug reference: 3469 Logged by: SRIDHARAN Email address: [EMAIL PROTECTED] PostgreSQL version: 1.4.2 Operating system: WinXP Description:SELECT QRY Details: SELECT (DATE '2001-07-30', DATE '2001-08-31') OVERLAPS (DATE '2001-0

Re: [BUGS] BUG #3469: SELECT QRY

2007-07-18 Thread Heikki Linnakangas
SRIDHARAN wrote: > SELECT (DATE '2001-07-30', DATE '2001-08-31') OVERLAPS (DATE '2001-08-04', > DATE '2002-08-04') > Retrutns : t > > SELECT (DATE '2007-07-30', DATE '2007-07-31') OVERLAPS (DATE '2007-07-31', > DATE '2007-07-31') > Returns : f That's intentional. SQL OVERLAPS operator treats the

[BUGS] BUG #3471: Failed to set permissions on created files

2007-07-18 Thread Jairo
The following bug has been logged online: Bug reference: 3471 Logged by: Jairo Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.4 Operating system: Windows 2003 Server Description:Failed to set permissions on created files Details: I always get that error ev

Re: [BUGS] BUG #3459: Query Error : plan should not reference subplan's variable

2007-07-18 Thread Tom Lane
"David Sanchez i Gregori" <[EMAIL PROTECTED]> writes: > Description:Query Error : plan should not reference subplan's > variable If it helps, I've applied the attached patch to fix this. > I found these error in all 8.x on Windows XP SP 2 (32 bits) , Linux 32 bits, > and Linux AMD64. AFA