Re: [BUGS] BUG #6296: High level backend-write activity on db

2011-11-16 Thread Maxim Boguk
> On Wed, Nov 16, 2011 at 4:07 AM, Maksym Boguk wrote: >> Again I not sure it is actual bug or something else go wrong with my >> database. >> >> One of my databases just started produce 256 wal segments in 5 minutes >> instead of 100-200 wal segments per hour (averages). >> >> In the same time wr

Re: [BUGS] BUG #6296: High level backend-write activity on db

2011-11-16 Thread Robert Haas
On Wed, Nov 16, 2011 at 4:07 AM, Maksym Boguk wrote: > Again I not sure it is actual bug or something else go wrong with my > database. > > One of my databases just started produce 256 wal segments in 5 minutes > instead of 100-200 wal segments per hour (averages). > > In the same time write and r

Re: [BUGS] BUG #6292: java.sql.PreparedStatement.setNull() throws PSQLException

2011-11-16 Thread Kris Jurka
On Mon, 14 Nov 2011, David Pinheiro wrote: > > Bug reference: 6292 > PostgreSQL version: 8.4 > Description:java.sql.PreparedStatement.setNull() throws > PSQLException > Details: > > I'm trying to make: > java.sql.PreparedStatement.setNull(1,java.sql.Types.NULL); > > org.postgres

Re: [BUGS] BUG #6293: JDBC driver performance

2011-11-16 Thread Kris Jurka
On Tue, 15 Nov 2011, Teun Hoogendoorn wrote: > > The following bug has been logged online: > > Bug reference: 6293 > PostgreSQL version: 9.1 > Description:JDBC driver performance > Details: > > Using the postgresql-9.1-901.jdbc3.jar driver instead of > postgresql-9.0-801.jdbc3.j

Re: [BUGS] Cannot dump 8.4.8 database using later versions

2011-11-16 Thread Josh Berkus
> The least painful solution might be to always quote *every* identifier > in commands sent to the source server, since we don't especially care > how nice-looking those are. I've never been clear on why we don't do that in the first place. -- Josh Berkus PostgreSQL Experts Inc. http://pgexpert

Re: [BUGS] BUG #6295: Update fails on empty concatenated strings

2011-11-16 Thread Tom Lane
I wrote: > You might possibly want to spell > the above as SET comment = '...' || coalesce(comment, null) ... Sheesh. coalesce(comment, '') of course. Need more caffeine. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes

Re: [BUGS] BUG #6295: Update fails on empty concatenated strings

2011-11-16 Thread Tom Lane
"Jonas Forsman" writes: > sql: > UPDATE user SET comment= E'[2011-11-16] Note to myself no: 171\\n' || > comment WHERE userid=1 > This query fails if comment is an empty string or null. Define "fails". Personally I'm wondering whether you remembered that concatenation of a null with something e

[BUGS] BUG #6295: Update fails on empty concatenated strings

2011-11-16 Thread Jonas Forsman
The following bug has been logged online: Bug reference: 6295 Logged by: Jonas Forsman Email address: jfo...@hotmail.com PostgreSQL version: 8.4.9 Operating system: Ubuntu 10.04 LTS Description:Update fails on empty concatenated strings Details: Field description (n

[BUGS] BUG #6296: High level backend-write activity on db

2011-11-16 Thread Maksym Boguk
The following bug has been logged online: Bug reference: 6296 Logged by: Maksym Boguk Email address: maxim.bo...@gmail.com PostgreSQL version: 9.0.5 Operating system: Linux RedHat Description:High level backend-write activity on db Details: Again I not sure it is ac

[BUGS] Re: BUG #6294: character 0xefbd9e of encoding "UTF8" has no equivalent in "BIG5"

2011-11-16 Thread CN
The following UTF8 character can not be converted to big5, either: CST ERROR: character 0xe28895 of encoding "UTF8" has no equivalent in "BIG5" Again, iconv has no problem with the conversion: iconv -f utf8 -t big5 Regards CN -- http://www.fastmail.fm - Send your email first class -- Sen