Re: [BUGS] BUG #7593: Unexpected query result combining or and in operators

2012-10-10 Thread Tom Lane
demur...@ockham-solutions.fr writes: > After a little while (probably after the analyze), the query plan is changed > and only 2 results are returned ! > "Merge Join (cost=33.31..39.69 rows=1 width=24)" > " Merge Cond: (i.numero_id = n.numero_id)" > ... > " -> Index Only Scan using numero_pkey

[BUGS] BUG #7593: Unexpected query result combining or and in operators

2012-10-10 Thread demurcia
The following bug has been logged on the website: Bug reference: 7593 Logged by: DE MURCIA Julien Email address: demur...@ockham-solutions.fr PostgreSQL version: 9.2.1 Operating system: Windows 7 Description: Hello, I am trying to run this query: select n.numero_id,

[BUGS] BUG #7594: "tuple concurrently updated" error on concurrent GRANT ON DATABASE statements

2012-10-10 Thread max
The following bug has been logged on the website: Bug reference: 7594 Logged by: Reinhard Max Email address: m...@suse.de PostgreSQL version: 9.1.6 Operating system: openSUSE Description: Is it intentional, that concurrent GRANT statements for the same database may re

Re: [BUGS] BUG #7534: walreceiver takes long time to detect n/w breakdown

2012-10-10 Thread Heikki Linnakangas
On 04.10.2012 13:12, Amit kapila wrote: Following changes are done to support replication timeout in sender as well as receiver: 1. One new configuration parameter wal_receiver_timeout is added to detect timeout at receiver task. 2. Existing parameter replication_timeout is renamed to wal_send

[BUGS] BUG #7592: Installation of PostGresql at c:\Progam files folder does not create right permission on data folder

2012-10-10 Thread devenmthaker
The following bug has been logged on the website: Bug reference: 7592 Logged by: Deven Email address: devenmtha...@gmail.com PostgreSQL version: 9.0.3 Operating system: Windows 2008 R2 WITH SP1 (64 BITS) Description: We are installing our application which internally

Re: [BUGS] BUG #6510: A simple prompt is displayed using wrong charset

2012-10-10 Thread Noah Misch
Hi Alexander, I was able to reproduce the problem based on your description and test case, and your change does resolve it for me. On Tue, Mar 20, 2012 at 11:50:14PM +0400, Alexander LAW wrote: > Thanks, I've understood your point. > Please look at the patch. It implements the first way and it ma

Re: [BUGS] BUG #7557: Transaction sees outdated grants.

2012-10-10 Thread Piotr Czachur
Tom, On 09/19/2012 11:15 PM, Tom Lane wrote: zim...@gmail.com writes: After upgrading from 9.1 to 9.2 I noticed that behaviour of veryfying table permissions during transaction has changed, and may be just wrong. Fixed (or at least restored to the historical behavior). Thanks for the report!