Re: [BUGS] Hanging with pg_restore and large objects

2011-11-01 Thread Alexander
It does not look like a disk issue - syslog doesn't report any problems, postgresql also seems to work fine. I'll try to make an SQL dump from backup file, but before that I'll try another backup file - probably the one I try to restore is broken due to some reasons (it was transfered over the ne

Re: [BUGS] Add statistics_collector_listen_addresses to fix hard-coding of "localhost"

2011-11-01 Thread Robert Young
On Fri, Oct 28, 2011 at 15:40, Robert Young wrote: > Which wrong? > 1.I got no money to buy a good machine to run both the services and database. > 2.I got no money to buy a good machine to run both the services and > client applications. > 3.Client applications hard-coding "localhost". > 4.PG har

Re: [BUGS] Add statistics_collector_listen_addresses to fix hard-coding of "localhost"

2011-11-01 Thread John R Pierce
On 11/01/11 1:04 AM, Robert Young wrote: 3.Client applications hard-coding "localhost". > 4.PG hard-coding "localhost". Since They are equivalent,the answer is obvious: Both #3 and #4 are wrong. as Tom Lane already said, and I'll quote again.. Look, we will explain this once more. Postgres

Re: [BUGS] Add statistics_collector_listen_addresses to fix hard-coding of "localhost"

2011-11-01 Thread Robert Young
You quoted Tom Lane. But I already replied him as following, So I quote mine again: > On Fri, Oct 28, 2011 at 17:12, Robert Young wrote: >> It is client applications and services,NOT client applications and database. >> It just term's (client applications, services) misleading. >> To the system v

Re: [BUGS] BUG #6279: quoting needed for column name with non ascii chars

2011-11-01 Thread Laurian Vostinar
SQL executor, of course. We actually execute the sql statement from Java program and behavior is not consistent. Why are quotes needed for Windows but not on Linux, Mac? Laurian On 31.10.2011 19:30, Pavel Golub wrote: Hello, Laurian. You wrote: LV> The following bug has been logged online

[BUGS] BUG #6282: psql.exe cannot recognize specific 2byte SJIS character

2011-11-01 Thread
The following bug has been logged online: Bug reference: 6282 Logged by: Email address: ikez...@tjsys.co.jp PostgreSQL version: 9.1.1 Operating system: Windows XP Description:psql.exe cannot recognize specific 2byte SJIS character Details: psql.exe cannot recognize

[BUGS] BUG #6283: About the behavior of indexscan in case there are some NULL values.

2011-11-01 Thread Naoya Anzai
The following bug has been logged online: Bug reference: 6283 Logged by: Naoya Anzai Email address: anzai-na...@mxu.nes.nec.co.jp PostgreSQL version: 9.1.1 Operating system: RHEL5.5 Description:About the behavior of indexscan in case there are some NULL values. Detail

Re: [BUGS] BUG #6282: psql.exe cannot recognize specific 2byte SJIS character

2011-11-01 Thread Itagaki Takahiro
On Wed, Nov 2, 2011 at 09:52, wrote: > Bug reference:      6282 > PostgreSQL version: 9.1.1 > Operating system:   Windows XP > Description:        psql.exe cannot recognize specific 2byte SJIS character > Details: > psql.exe cannot recognize specific 2byte SJIS characters. > > These characters ha