[BUGS] BUG #7532: cannot update to 9.2

2012-09-12 Thread arsen_mmx
The following bug has been logged on the website: Bug reference: 7532 Logged by: arnes Email address: arsen_...@163.com PostgreSQL version: 9.1.5 Operating system: ubuntu 11.04 natty Description: I cannot update my postgresql to 9.2. Is there anything wrong with the r

Re: [BUGS] BUG #7532: cannot update to 9.2

2012-09-12 Thread Martin Pitt
Hello Arsen, arsen_...@163.com [2012-09-12 1:48 +]: > Bug reference: 7532 > Logged by: arnes > Email address: arsen_...@163.com > PostgreSQL version: 9.1.5 > Operating system: ubuntu 11.04 natty > Description: > > I cannot update my postgresql to 9.2. Is there an

Re: [BUGS] BUG #6704: ALTER EXTENSION postgis SET SCHEMA leaves dangling relations

2012-09-12 Thread Dimitri Fontaine
Hi, Sorry for being late at the party… been distracted away… Bruce Momjian writes: > On Fri, Jun 22, 2012 at 10:37:10PM -0400, Tom Lane wrote: >> j...@pgexperts.com writes: >> > DROP and CREATE extension appear to work fine, but if you ALTER EXTENSION >> > postgis SET SCHEMA foo, it leave

Re: [BUGS] BUG #7516: PL/Perl crash

2012-09-12 Thread Marko Tiikkaja
On 9/12/12 1:50 AM, Tom Lane wrote: Marko Tiikkaja writes: Joel Jacobson managed to narrow it down to this test case, which crashes consistently on Ubuntu 12.04 both with and without your patch. I, however, wasn't able to reproduce the problem on my OS X Mountain Lion. Doesn't reproduce for

[BUGS] BUG #7533: Client is not able to connect cascade standby incase basebackup is taken from hot standby

2012-09-12 Thread amit . kapila
The following bug has been logged on the website: Bug reference: 7533 Logged by: Amit Kapila Email address: amit.kap...@huawei.com PostgreSQL version: 9.2.0 Operating system: Suse Description: M host is primary, S host is standby and CS host is cascaded standby. 1.S

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

2012-09-12 Thread amit . kapila
The following bug has been logged on the website: Bug reference: 7534 Logged by: Amit Kapila Email address: amit.kap...@huawei.com PostgreSQL version: 9.2.0 Operating system: Suse 10 Description: 1. Both master and standby machine are connected normally, 2. then you

Re: [BUGS] BUG #6704: ALTER EXTENSION postgis SET SCHEMA leaves dangling relations

2012-09-12 Thread Alvaro Herrera
Excerpts from Dimitri Fontaine's message of mié sep 12 06:51:43 -0300 2012: > Hi, > > Sorry for being late at the party… been distracted away… Welcome ;-) > > On Fri, Jun 22, 2012 at 10:37:10PM -0400, Tom Lane wrote: > >> A bit of looking shows that ALTER EXTENSION SET SCHEMA calls > >> AlterOb

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

2012-09-12 Thread Magnus Hagander
On Wed, Sep 12, 2012 at 1:54 PM, wrote: > The following bug has been logged on the website: > > Bug reference: 7534 > Logged by: Amit Kapila > Email address: amit.kap...@huawei.com > PostgreSQL version: 9.2.0 > Operating system: Suse 10 > Description: > > 1. Both master and s

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

2012-09-12 Thread Fujii Masao
On Wed, Sep 12, 2012 at 8:54 PM, wrote: > The following bug has been logged on the website: > > Bug reference: 7534 > Logged by: Amit Kapila > Email address: amit.kap...@huawei.com > PostgreSQL version: 9.2.0 > Operating system: Suse 10 > Description: > > 1. Both master and s

Re: [BUGS] initdb.exe changes --locale option

2012-09-12 Thread Mike Toews
I've found a general solution: with the locale string, replace the first ", " (comma space) with "_". Around line 33 of initcluster.vbs, add: strLocale = Replace(strLocale,", ","_",1,1) I think it is fine to show "English, New Zealand" in the drop-down menu for the GUI installer, but initcluster

[BUGS] Re: Probable bug with CreateFakeRelcacheEntry (now with reproducible test case)

2012-09-12 Thread Jeff Davis
Indeed, this is a nasty bug that leads to data corruption. The following sequence results in corruption of the visibility map, but I believe it can be shown to cause problems for a btree or GIN index as well. So it's recoverable if you do a VACUUM or a reindex. drop table foo; create table foo(i i

Re: [BUGS] BUG #7533: Client is not able to connect cascade standby incase basebackup is taken from hot standby

2012-09-12 Thread Fujii Masao
On Wed, Sep 12, 2012 at 8:47 PM, wrote: > The following bug has been logged on the website: > > Bug reference: 7533 > Logged by: Amit Kapila > Email address: amit.kap...@huawei.com > PostgreSQL version: 9.2.0 > Operating system: Suse > Description: > > M host is primary, S ho

[BUGS] BUG #7535: ERROR: variable not found in subplan target list

2012-09-12 Thread ldm
The following bug has been logged on the website: Bug reference: 7535 Logged by: Louis-David Mitterrand Email address: l...@apartia.fr PostgreSQL version: 9.2.0 Operating system: debian testing Description: /*error in 9.2*/ drop database error92; create database error

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

2012-09-12 Thread Amit Kapila
On Wednesday, September 12, 2012 10:12 PM Magnus Hagander wrote: On Wed, Sep 12, 2012 at 1:54 PM, wrote: >> The following bug has been logged on the website: > >> Bug reference: 7534 >> Logged by: Amit Kapila >> Email address: amit.kap...@huawei.com >> PostgreSQL version: 9.2.0

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

2012-09-12 Thread Amit Kapila
On Wednesday, September 12, 2012 10:15 PM Fujii Masao On Wed, Sep 12, 2012 at 8:54 PM, wrote: >> The following bug has been logged on the website: >> >> Bug reference: 7534 >> Logged by: Amit Kapila >> Email address: amit.kap...@huawei.com >> PostgreSQL version: 9.2.0 >> Operat

Re: [BUGS] BUG #7533: Client is not able to connect cascade standby incase basebackup is taken from hot standby

2012-09-12 Thread Amit Kapila
On Thursday, September 13, 2012 12:34 AM Fujii Masao wrote: On Wed, Sep 12, 2012 at 8:47 PM, wrote: >> The following bug has been logged on the website: > >> Bug reference: 7533 >> Logged by: Amit Kapila >> Email address: amit.kap...@huawei.com >> PostgreSQL version: 9.2.0 >> O