Re: [BUGS] BUG #4286: ORDER BY returns inconsistent results when using LIMIT on a integer column set to default values

2008-07-08 Thread Tom Lane
"Heikki Linnakangas" <[EMAIL PROTECTED]> writes: > Thibauld Favre wrote: >> Here's what I get as a result on my server. See how 'a' is systematically >> put at the end of the result set until the LIMIT clause reaches the value 8. >> Above 8, the results get consistent again. > Doesn't look like a

Re: [BUGS] BUG #4276: Feature request aggregate indexes

2008-07-08 Thread Simon Riggs
On Tue, 2008-07-01 at 13:27 +, x wrote: > The following bug has been logged online: > > Bug reference: 4276 > Logged by: x > Email address: [EMAIL PROTECTED] > PostgreSQL version: n/a > Operating system: n/a > Description:Feature request aggregate indexes > Detail

Re: [BUGS] BUG #4286: ORDER BY returns inconsistent results when using LIMIT on a integer column set to default values

2008-07-08 Thread Alvaro Herrera
Thibauld Favre escribió: > Here's a little SQL script that recreate the bug I encounter on my app. > Basically, on certain circonstances, the first value of the table (here 'a') > is constantly returned at the end of the result set, thus creating > inconsistency between queries. I'm not sure I'm c

[BUGS] BUG #4287: Will not boot

2008-07-08 Thread Bob Thompson
The following bug has been logged online: Bug reference: 4287 Logged by: Bob Thompson Email address: [EMAIL PROTECTED] PostgreSQL version: 2.3.0 Operating system: MAC OSX 10.5.4 Description:Will not boot Details: Bob, This note applies to only one computer he did no

Re: [BUGS] BUG #4286: ORDER BY returns inconsistent results when using LIMIT on a integer column set to default values

2008-07-08 Thread Heikki Linnakangas
Thibauld Favre wrote: Here's a little SQL script that recreate the bug I encounter on my app. Basically, on certain circonstances, the first value of the table (here 'a') is constantly returned at the end of the result set, thus creating inconsistency between queries. I'm not sure I'm clear so he

[BUGS] BUG #4286: ORDER BY returns inconsistent results when using LIMIT on a integer column set to default values

2008-07-08 Thread Thibauld Favre
The following bug has been logged online: Bug reference: 4286 Logged by: Thibauld Favre Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3.3 Operating system: Ubuntu Hardy Heron (8.04.1) Description:ORDER BY returns inconsistent results when using LIMIT on a int

Re: [BUGS] problems instaling

2008-07-08 Thread gildas prime
You have a previous postgres user installed in your computer, you can delete it (if no longer used…) with the command : net.exe user postgres /delete _ De : [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] De la part de filipe moreira Envoyé : mardi 8 juillet 2008 01:06 À : pgsql-bugs@postgre

[BUGS] problems instaling

2008-07-08 Thread filipe moreira
Hello support Im having problem instaling postgresql. I nead the program to use poker tracker in windows vista. when im finishin the instalation apears this message: (User "postegres" could not be created: The user account already exists.!) Can you help me?? thanks Filipe Moreira _