Re: [BUGS] BUG #6342: libpq blocks forever in "poll" function

2011-12-16 Thread Craig Ringer
On 12/16/2011 03:45 PM, andreagra...@sogeasoft.com wrote: The following bug has been logged on the website: Bug reference: 6342 Logged by: Andrea Grassi Email address: andreagra...@sogeasoft.com PostgreSQL version: 8.4.8 Operating system: SUSE SLES 10 SP4 64 BIT Description:

Re: [BUGS] BUG #6342: libpq blocks forever in "poll" function

2011-12-16 Thread Craig Ringer
On 12/16/2011 03:45 PM, andreagra...@sogeasoft.com wrote: The following bug has been logged on the website: Bug reference: 6342 Logged by: Andrea Grassi Email address: andreagra...@sogeasoft.com PostgreSQL version: 8.4.8 Operating system: SUSE SLES 10 SP4 64 BIT Description:

[BUGS] TAS patch for building on armel/armhf thumb

2011-12-16 Thread Martin Pitt
Hello, if you build postgresql (tested all releases from 8.4 up to trunk) for ARM with the -mthumb instruction set (much better performance), it fails with gcc -g -O2 -g -Wall -O2 -fPIC -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -fno-strict-aliasing -

Re: [BUGS] TAS patch for building on armel/armhf thumb

2011-12-16 Thread Heikki Linnakangas
On 16.12.2011 11:36, Martin Pitt wrote: if you build postgresql (tested all releases from 8.4 up to trunk) for ARM with the -mthumb instruction set (much better performance), it fails with gcc -g -O2 -g -Wall -O2 -fPIC -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -We

Re: [BUGS] Postgresql 9.1.2 - abnormal memory usage

2011-12-16 Thread Havasvölgyi Ottó
Hi, A simple query "insert into mytable default values" on a single serial-column table also leaks. It can also produced by pgbench. On Windows and Linux too. Best regards, Otto 2011/12/12 Jochen Erwied > Monday, December 12, 2011, 12:33:03 PM you wrote: > > > On 12.12.2011 13:16, Matteo Bec

Re: [BUGS] user names & non-ASCII

2011-12-16 Thread Pavel Holec
PGCLIENTENCODING='latin2' - doesn't help (SetEnvironmentVariable) SET CLIENT_ENCODING TO - doesn't help (too late) connect with "only ascii" not possible (users are set) SET role TO specialcharsrole? google doesn't know On servers we have 8.4.7 not 9.1.1 In manual is PQconnectdb() with options="cl

R: [BUGS] BUG #6342: libpq blocks forever in "poll" function

2011-12-16 Thread Andrea Grassi
The client program and the postgres server are on the same host, client connects to 127.0.0.1. In the meantime, my original program blocks (not my example but very probably the reasons are the same). I typed "ps -C testprogramname -o wchan:80=" and the output was only a single dash ( "-" ). I

Re: [BUGS] BUG #6340: to_timestamp() miscalculates

2011-12-16 Thread Hans-Henrik Fuxelius
It seems not possible to suppress to_timestamp from doing daylight saving conversion, I have GPS timeseries that looks perfect in the 'timestamp without time zone' save one value that wreck the whole time serie, does that mean that time series cant be stored in time stamps? /Hans-Henrik On Thu, D

Re: [BUGS] user names & non-ASCII

2011-12-16 Thread Pavel Holec
User name with PQescapeBytea also doesn't help. Pavel -Original Message- From: Pavel Stehule [mailto:pavel.steh...@gmail.com] Sent: Friday, December 16, 2011 12:18 AM To: Pavel Holec Cc: pgsql-bugs@postgresql.org Subject: Re: [BUGS] user names & non-ASCII Hello this is not bug you can

[BUGS] fatal flex error in guc-file.l kills the postmaster

2011-12-16 Thread Noah Misch
While testing the configuration include directory patch, I decided to try the regular postgresql.conf "include" on a directory: include 'base' Reloading the configuration then rather rudely kills the postmaster: FATAL: input in flex scanner failed Setting aside whether we should offer a be

[BUGS] BUG #6343: PGTYPES library missing qualifiers

2011-12-16 Thread kojiro
The following bug has been logged on the website: Bug reference: 6343 Logged by: Daniel Loffgren Email address: koj...@hello-channel.com PostgreSQL version: 9.1.1 Operating system: NetBSD Description: In the ecpg PGTYPES library, there are functions like this: exter

Re: R: [BUGS] BUG #6342: libpq blocks forever in "poll" function

2011-12-16 Thread Craig Ringer
On 16/12/2011 10:10 PM, Andrea Grassi wrote: The client program and the postgres server are on the same host, client connects to 127.0.0.1. In the meantime, my original program blocks (not my example but very probably the reasons are the same). I typed "ps -C testprogramname -o wchan:80=" and