Re: [BUGS] BUG #6141: PG Admin's SQL editor can't handle large files

2011-08-02 Thread pasman pasmański
Hi. This is not postgresql bug. Try pgadmin-support list. Btw psql < script is too complicated? 2011/8/2, michael : > > The following bug has been logged online: > > Bug reference: 6141 > Logged by: michael > Email address: mpa...@yahoo.com > PostgreSQL version: 9.0 > Operating

[BUGS] BUG #6141: PG Admin's SQL editor can't handle large files

2011-08-02 Thread michael
The following bug has been logged online: Bug reference: 6141 Logged by: michael Email address: mpa...@yahoo.com PostgreSQL version: 9.0 Operating system: Windows Description:PG Admin's SQL editor can't handle large files Details: Hi, I have a script writing an ins

Re: [BUGS] PostgreSQL 8.4

2011-08-02 Thread Craig Ringer
On 3/08/2011 12:11 AM, Kevin Grittner wrote: Glonet NV / Mathieu Aras wrote: Can we install PostgreSQL 8.4 on a server 2008? Is it X64 and X32 compatible? This is not a bug. A more appropriate list for this question would have been pgsql-general. I'm not sure what "server 2008" is, but if

Re: [BUGS] BUG #6140: PostgreSQL Server Service Not Starting

2011-08-02 Thread Craig Ringer
On 2/08/2011 8:01 PM, Steve Boyd wrote: "could not open process token: error code 5" The service account is in the local administrators group and has full control over the data directory. AFAIK PostgreSQL service account should *NOT* be part of the local administrators group. That said, t

Re: [BUGS] PostgreSQL 8.4

2011-08-02 Thread Kevin Grittner
Glonet NV / Mathieu Aras wrote: > Can we install PostgreSQL 8.4 on a server 2008? Is it X64 and X32 > compatible? This is not a bug. A more appropriate list for this question would have been pgsql-general. I'm not sure what "server 2008" is, but if it's some form of Windows, version 8.4 sh

[BUGS] PostgreSQL 8.4

2011-08-02 Thread Glonet NV / Mathieu Aras
Dear sir, Can we install PostgreSQL 8.4 on a server 2008? Is it X64 and X32 compatible? Best Regards, Mathieu Mathieu Aras Systeembeheer & Ondersteuning math...@glonet.be http://www.glonet.be Glonet NV Beverestraat 59 B-9700 Oudenaarde tel: +

Re: [BUGS] backend for database 'A' crashes/is killed -> corrupt index in database 'B'

2011-08-02 Thread Jon Nelson
On Thu, Mar 31, 2011 at 2:58 AM, Heikki Linnakangas wrote: > On 30.03.2011 21:06, Jon Nelson wrote: >> >> The short version is that if a postgresql backend is killed (by the Linux >> OOM handler, or kill -9, etc...) while operations are >> taking place in a *different* backend, corruption is intro

[BUGS] BUG #6140: PostgreSQL Server Service Not Starting

2011-08-02 Thread Steve Boyd
The following bug has been logged online: Bug reference: 6140 Logged by: Steve Boyd Email address: sboy...@yahoo.com PostgreSQL version: 8.3.12 Operating system: Windows Server 2003 R2 SP2 Description:PostgreSQL Server Service Not Starting Details: Good morning! I'

Re: [BUGS] BUG #6139: LIMIT doesn't return correct result when the value is huge

2011-08-02 Thread Heikki Linnakangas
On 02.08.2011 09:25, Hitoshi Harada wrote: db1=# select count(*) from test_xy; count --- 31 (1 row) db1=# select * from test_xy order by x LIMIT 9223372036854775807 OFFSET 6; gid | x | y -++ 13 | -0.591943957968

Re: [BUGS] BUG #6139: LIMIT doesn't return correct result when the value is huge

2011-08-02 Thread Alex Hunsaker
On Tue, Aug 2, 2011 at 00:25, Hitoshi Harada wrote: > db1=# select * from test_xy order by x LIMIT 9223372036854775807 OFFSET 6; [ ...] > db1=# select * from test_xy order by x LIMIT pow(2, 63); > ERROR:  bigint out of range > ERROR:  bigint out of range > > Maybe a parser converts literal unexp