[BUGS] BUG #7999: Regexp with utf8

2013-03-27 Thread somloieater
The following bug has been logged on the website: Bug reference: 7999 Logged by: david Email address: somloiea...@gmail.com PostgreSQL version: 9.1.8 Operating system: linux Description: \y and \Y do not behave correctly next to multibyte utf-8 characters - they seem

[BUGS] BUG #8000: ExclusiveLock on a simple SELECT ?

2013-03-27 Thread roberto . menoncin
The following bug has been logged on the website: Bug reference: 8000 Logged by: Roberto Email address: roberto.menon...@netspa.it PostgreSQL version: 9.2.3 Operating system: CentOS 5.6 (Final) Description: Hy, after upgrading to version 9.2.3 we having a performance

Re: [BUGS] BUG #8000: ExclusiveLock on a simple SELECT ?

2013-03-27 Thread Heikki Linnakangas
On 27.03.2013 15:07, roberto.menon...@netspa.it wrote: after upgrading to version 9.2.3 we having a performance degradation. We are investigating the matter on several fronts. We've seen that Postgres (9.2.3) creates ExclusiveLock even with simple SELECT * From myschema.mytable. You mean like t

Re: [BUGS] BUG #7999: Regexp with utf8

2013-03-27 Thread Tom Lane
somloiea...@gmail.com writes: > PostgreSQL version: 9.1.8 > I've checked with a few other characters which are >1byte in utf8. U+00F0 > counds as \w, but nothing I've tried > FF matches. I wonder if it's > something to do with >256? Yup. This is partially resolved in PG 9.2, but will never be f

[BUGS] Re: BUG #7969: Postgres Recovery Fatal With: "incorrect local pin count:2"

2013-03-27 Thread Josh Berkus
Folks, So I'm a bit surprised that this bug report hasn't gotten a follow-up. Does this sound like the known 9.2.2 corruption issue, or is it potentially something else? -- Josh Berkus PostgreSQL Experts Inc. http://pgexperts.com -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)

Re: [BUGS] Re: BUG #7969: Postgres Recovery Fatal With: "incorrect local pin count:2"

2013-03-27 Thread Heikki Linnakangas
On 27.03.2013 20:27, Josh Berkus wrote: Folks, So I'm a bit surprised that this bug report hasn't gotten a follow-up. Does this sound like the known 9.2.2 corruption issue, or is it potentially something else? It seems like a new issue. At a quick glance, I think there's a bug in heap_xlog_up

Re: [BUGS] Re: BUG #7969: Postgres Recovery Fatal With: "incorrect local pin count:2"

2013-03-27 Thread Heikki Linnakangas
On 27.03.2013 21:04, Heikki Linnakangas wrote: On 27.03.2013 20:27, Josh Berkus wrote: Folks, So I'm a bit surprised that this bug report hasn't gotten a follow-up. Does this sound like the known 9.2.2 corruption issue, or is it potentially something else? It seems like a new issue. At a quic

[BUGS] BUG #8001: Cannot install Slony

2013-03-27 Thread eimbassahy
The following bug has been logged on the website: Bug reference: 8001 Logged by: Eduardo Email address: eimbass...@yahoo.com.br PostgreSQL version: 8.4.11 Operating system: windows7 Home Premium SP1 i64 Description: I,m trying to install the Slony in my Postgres 8.4.

Re: [BUGS] Re: BUG #7969: Postgres Recovery Fatal With: "incorrect local pin count:2"

2013-03-27 Thread Tom Lane
Heikki Linnakangas writes: > This bug was introduced by commit > 8805ff6580621d0daee350826de5211d6bb36ec3, in 9.2.2 (and 9.1.7 and > 9.0.11), which fixed multiple WAL replay issues with Hot Standby. Ooops. Thanks for finding that. regards, tom lane -- Sent via pgsql

Re: [BUGS] BUG #8001: Cannot install Slony

2013-03-27 Thread Michael Paquier
Hi, This is not really a PostgreSQL bug, so you should contact directly Slony people using a mailing list like this one: http://lists.slony.info/mailman/listinfo/slony1-general Thanks, -- Michael