Re: [BUGS] BUG #7756: When upgrading postgis extension get row is too big: size 9272, maximum size 8160

2012-12-21 Thread Paragon Corporation
>> "Paragon Corporation" writes: >>> I assumed that the : >>> pg_catalog.pg_extension_config_dump >>> Calls would overwrite each subsequent for a given object for a given >>> extension. So I have that in my upgrade script as well should we add >> more spatial_ref_sys records we want to avoid

[BUGS] pg_basebackup fails if a data file is removed

2012-12-21 Thread Heikki Linnakangas
When pg_basebackup copies data files, it does basically this: if (lstat(pathbuf, &statbuf) != 0) { if (errno != ENOENT) ereport(ERROR, (errcode_for_file_access(), errmsg("could not stat file or directory \"%

Re: [BUGS] pg_basebackup fails if a data file is removed

2012-12-21 Thread Magnus Hagander
On Fri, Dec 21, 2012 at 2:28 PM, Heikki Linnakangas wrote: > When pg_basebackup copies data files, it does basically this: > >> if (lstat(pathbuf, &statbuf) != 0) >> { >> if (errno != ENOENT) >> ereport(ERROR, >> (errcode_for_file_access(), >

Re: [BUGS] pg_basebackup fails if a data file is removed

2012-12-21 Thread Heikki Linnakangas
On 21.12.2012 15:30, Magnus Hagander wrote: On Fri, Dec 21, 2012 at 2:28 PM, Heikki Linnakangas wrote: When pg_basebackup copies data files, it does basically this: if (lstat(pathbuf,&statbuf) != 0) { if (errno != ENOENT) ereport(ERROR,

[BUGS] BUG #7766: Running a DML statement that affects more than 4 billion rows results in an exception

2012-12-21 Thread zelaine
The following bug has been logged on the website: Bug reference: 7766 Logged by: Zelaine Fong Email address: zela...@amazon.com PostgreSQL version: 8.4.0 Operating system: Linux Description: The updateCount field in the ResultHandler interface in Java is defined as an

[BUGS] BUG #7767: pg_ctl allows postgres running under administrator's privilege

2012-12-21 Thread yangyd
The following bug has been logged on the website: Bug reference: 7767 Logged by: yangyd Email address: yan...@cn.fujitsu.com PostgreSQL version: 9.2.2 Operating system: Windows 7 Professional Description: I found that it's possible to start the postgres process as the

Re: [BUGS] BUG #7766: Running a DML statement that affects more than 4 billion rows results in an exception

2012-12-21 Thread Tom Lane
zela...@amazon.com writes: > The following bug has been logged on the website: > Bug reference: 7766 > Logged by: Zelaine Fong > Email address: zela...@amazon.com > PostgreSQL version: 8.4.0 > Operating system: Linux > Description: > The updateCount field in the Result

[BUGS] BUG #7768: Support for TCP Keepalive parameters

2012-12-21 Thread me
The following bug has been logged on the website: Bug reference: 7768 Logged by: Yura Gotovko Email address: m...@yugo.su PostgreSQL version: 9.2.2 Operating system: FreeBSD 9.1 Description: Compile PostgreSQL 9.2.2 on FreeBSD 9.1. Each database connection throws thr

Re: [JDBC] [BUGS] BUG #7766: Running a DML statement that affects more than 4 billion rows results in an exception

2012-12-21 Thread Dave Cramer
Thanks Tom. So an unsigned long won't fit inside a java long either, but hopefully it will never be necessary. That would be a huge number of changes. Dave Dave Cramer dave.cramer(at)credativ(dot)ca http://www.credativ.ca On Fri, Dec 21, 2012 at 11:47 AM, Tom Lane wrote: > zela...@amazon.c

Re: [JDBC] [BUGS] BUG #7766: Running a DML statement that affects more than 4 billion rows results in an exception

2012-12-21 Thread Tom Lane
Dave Cramer writes: > So an unsigned long won't fit inside a java long either, but hopefully it > will never be necessary. That would be a huge number of changes. I think we'll all be safely dead by the time anybody manages to process 2^63 rows in one PG command ;-). If you can widen the value f