Re: [BUGS] BUG #4996: postgres.exe memory consumption keeps going up

2009-08-25 Thread Craig Ringer
On 26/08/2009 9:25 AM, WANGRUNGVICHAISRI, SHIVESH wrote: Hi, I have uploaded everything that you should need here: http://www.filefactory.com/file/ah334c6/n/Pgsql_Leak_zip I notice that you used the Windows Task Manager to monitor memory usage, rather than Process Explorer. There's a reason

Re: [BUGS] BUG #4999: select 'a' < 'A' is true, but should be false . . .

2009-08-25 Thread Alvaro Herrera
Brian Ceccarelli wrote: > If the words are the same words but letters have different case, then the > operator is case-sensitive. > If the words are not the same words, then the operator is case-insensitive > until the operator reaches the character position in both strings where the > letters bec

Re: [BUGS] BUG #4999: select 'a' < 'A' is true, but should be false . . .

2009-08-25 Thread Jaime Casanova
On Tue, Aug 25, 2009 at 8:38 PM, Brian Ceccarelli wrote: > > If the words are the same words but letters have different case, then the > operator is case-sensitive. > If the words are not the same words, then the operator is case-insensitive > until the operator reaches the character position in bo

Re: [BUGS] BUG #4999: select 'a' < 'A' is true, but should be false . . .

2009-08-25 Thread Tom Lane
"Brian Ceccarelli" writes: > After a long and careful study of this, this is a Postgres bug. > Postgres is boogering up the sort. The operators < >, and the "order by" > in the select statement are both case-sensitive and case-insensitive.It > is inconsistent. "Consistency" is not a ha

Re: [BUGS] BUG #4999: select 'a' < 'A' is true, but should be false . . .

2009-08-25 Thread Brian Ceccarelli
Actually Greg . . . After a long and careful study of this, this is a Postgres bug. Postgres is boogering up the sort. The operators < >, and the "order by" in the select statement are both case-sensitive and case-insensitive.It is inconsistent. It does not matter what my collating se

Re: [BUGS] BUG #4996: postgres.exe memory consumption keeps going up

2009-08-25 Thread WANGRUNGVICHAISRI, SHIVESH
Hi, I have uploaded everything that you should need here: http://www.filefactory.com/file/ah334c6/n/Pgsql_Leak_zip The zip file contains a readme.txt file that will explain everything. Please note that if you want to see that the test program itself is not leaking, then change every occurrence

Re: [BUGS] BUG #5011: Standby recovery unable to follow timeline change

2009-08-25 Thread Kevin Grittner
"James Bardin" wrote: > Is this currently possible, or do I have to send a full file-level > backup to sync the ex-master server with the new master? I believe you have to get a new base backup from the new master to the new standby. Consider rsync, which might do it *really* fast if not much

[BUGS] BUG #5011: Standby recovery unable to follow timeline change

2009-08-25 Thread James Bardin
The following bug has been logged online: Bug reference: 5011 Logged by: James Bardin Email address: jbar...@bu.edu PostgreSQL version: 8.4.0-1 Operating system: Centos 5.3 Description:Standby recovery unable to follow timeline change Details: This is another use ca

Re: [BUGS] BUG #5008: Server Startup Problem - When server is configured for SSL

2009-08-25 Thread Magnus Hagander
On Tue, Aug 25, 2009 at 08:11, Jalaj Negi wrote: > > The following bug has been logged online: > > Bug reference:      5008 > Logged by:          Jalaj Negi > Email address:      jalajsinghn...@gmail.com > PostgreSQL version: 8.4.0 > Operating system:   Windows XP with SP3 > Description:        Ser

Re: [BUGS] BUG #5009: Loss of information

2009-08-25 Thread David Fetter
On Tue, Aug 25, 2009 at 12:07:44PM +, Fernando Velloso Tanure wrote: > > The following bug has been logged online: > > Bug reference: 5009 > Logged by: Fernando Velloso Tanure > Email address: f_tan...@terra.com.br > PostgreSQL version: 8.1.11 > Operating system: CentOS5.

Re: [BUGS] BUG #5009: Loss of information

2009-08-25 Thread Craig Ringer
On 25/08/2009 8:07 PM, Fernando Velloso Tanure wrote: The following bug has been logged online: Bug reference: 5009 Logged by: Fernando Velloso Tanure Email address: f_tan...@terra.com.br PostgreSQL version: 8.1.11 Operating system: CentOS5.3 Red Hat Enterprise Linux RHEL D

[BUGS] BUG #5010: perl iconv function returns ? character

2009-08-25 Thread Lampa
The following bug has been logged online: Bug reference: 5010 Logged by: Lampa Email address: lamp...@gmail.com PostgreSQL version: 8.4.0 Operating system: Debian testing/unstable Description:perl iconv function returns ? character Details: See the difference (examp

[BUGS] BUG #5009: Loss of information

2009-08-25 Thread Fernando Velloso Tanure
The following bug has been logged online: Bug reference: 5009 Logged by: Fernando Velloso Tanure Email address: f_tan...@terra.com.br PostgreSQL version: 8.1.11 Operating system: CentOS5.3 Red Hat Enterprise Linux RHEL Description:Loss of information Details: Good a

[BUGS] BUG #5008: Server Startup Problem - When server is configured for SSL

2009-08-25 Thread Jalaj Negi
The following bug has been logged online: Bug reference: 5008 Logged by: Jalaj Negi Email address: jalajsinghn...@gmail.com PostgreSQL version: 8.4.0 Operating system: Windows XP with SP3 Description:Server Startup Problem - When server is configured for SSL Details: