[BUGS] BUG #8327: a bug of spgist index in a heavy write condition

2013-07-24 Thread hailong . li
The following bug has been logged on the website: Bug reference: 8327 Logged by: hailong.li Email address: hailong...@qunar.com PostgreSQL version: 9.2.4 Operating system: CentOS release 5.5 (Final) Description: http://www.postgresql.org/message-id/519a5917.40...@quna

Re: [BUGS] BUG #8327: a bug of spgist index in a heavy write condition

2013-07-24 Thread Andres Freund
Hi, On 2013-07-24 10:54:07 +, hailong...@qunar.com wrote: > The following bug has been logged on the website: > > Bug reference: 8327 > Logged by: hailong.li > Email address: hailong...@qunar.com > PostgreSQL version: 9.2.4 > Operating system: CentOS release 5.5 (Final) >

Re: [BUGS] BUG #8154: pg_dump throws error beacause of field called "new".

2013-07-24 Thread Willy-Bas Loos
Hi, The manual says: It is recommended that you use the pg_dump and pg_dumpall programs from the newer version of PostgreSQL, to take advantage of enhancements that might have been made in these programs. Current releases of the dump programs can read data from any server version back to 7.0. http

[BUGS] Single row INSERT on updatable VIEW on top of partitioned table is run against each inheriting table, giving multiple rows from single insert.

2013-07-24 Thread Terje Elde
Hi, Short summary: If I run a single INSERT against an updateable VIEW on top of a partitioned table, it's run against all the tables/partitions. I'd expect that with UPDATE and DELETE, but not with INSERT. Result is multiple rows for a single INSERT, one for each table. I ran into this on 9

Re: [BUGS] Single row INSERT on updatable VIEW on top of partitioned table is run against each inheriting table, giving multiple rows from single insert.

2013-07-24 Thread Terje Elde
On Jul 24, 2013, at 2:37 PM, Terje Elde wrote: > Short summary: > If I run a single INSERT against an updateable VIEW on top of a partitioned > table, it's run against all the tables/partitions. I'd expect that with > UPDATE and DELETE, but not with INSERT. Result is multiple rows for a single

[BUGS] BUG #8329: UPDATE x SET x.y = x.y + z does not work in PL/pgSQL

2013-07-24 Thread chmelarp
The following bug has been logged on the website: Bug reference: 8329 Logged by: Petr Email address: chmel...@fit.vutbr.cz PostgreSQL version: 9.2.4 Operating system: Fedora x64 Description: Hi there, we have an issue - if I run a query from a console, it runs OK. Wh

Re: [BUGS] BUG #8329: UPDATE x SET x.y = x.y + z does not work in PL/pgSQL

2013-07-24 Thread bricklen
On Wed, Jul 24, 2013 at 7:45 AM, wrote: > The following bug has been logged on the website: > > Bug reference: 8329 > Logged by: Petr > Email address: chmel...@fit.vutbr.cz > PostgreSQL version: 9.2.4 > Operating system: Fedora x64 > Description: > > Hi there, > we have an is

[BUGS] BUG #8326: pgbench tps wrong BUG

2013-07-24 Thread digoal
The following bug has been logged on the website: Bug reference: 8326 Logged by: digoal.zhou Email address: dig...@126.com PostgreSQL version: Unsupported/Unknown Operating system: CentOS 5.8 x64 Description: when client thread big, the tps without connection time wro

[BUGS] BUG #8328: Unable to start postgresql on the Debian machine.

2013-07-24 Thread vijayakumar . subas
The following bug has been logged on the website: Bug reference: 8328 Logged by: Vijay Email address: vijayakumar.su...@hp.com PostgreSQL version: Unsupported/Unknown Operating system: Debian Description: Hello, We are facing issue when trying to start postgresql on t

Re: [BUGS] BUG #8329: UPDATE x SET x.y = x.y + z does not work in PL/pgSQL

2013-07-24 Thread Pavel Stehule
Hello 2013/7/24 : > The following bug has been logged on the website: > > Bug reference: 8329 > Logged by: Petr > Email address: chmel...@fit.vutbr.cz > PostgreSQL version: 9.2.4 > Operating system: Fedora x64 > Description: > > Hi there, > we have an issue - if I run a query

Re: [BUGS] BUG #8329: UPDATE x SET x.y = x.y + z does not work in PL/pgSQL

2013-07-24 Thread Petr Chmelar
Dear Briklen and Pavel, Yes, the z. is a typo, it should be z.z ... I can send the complete query and tables tomorrow, also I'll try to make it simpler (the function is about 300 lines). Thanks for the early answers, Petr Dne 24.07.2013 17:14 napsal uživatel bricklen: On Wed, Jul 24, 2013 at 7

[BUGS] Single row INSERT on updatable VIEW on top of partitioned table is run against each inheriting table, giving multiple rows from single insert.

2013-07-24 Thread Terje Elde
Hi, Short summary: If I run a single INSERT against an updateable VIEW on top of a partitioned table, it's run against all the tables/partitions. I'd expect that with UPDATE and DELETE, but not with INSERT. Result is multiple rows for a single INSERT, one for each table. I ran into this on 9