Re: [BUGS] BUG #5245: Full Server Certificate Chain Not Sent to client

2010-05-26 Thread Craig Ringer
On 15/12/09 23:35, Brian Krug wrote: The following bug has been logged online: Bug reference: 5245 Logged by: Brian Krug Email address: bk...@usatech.com PostgreSQL version: 8.4.1 Operating system: Solaris 10 Description:Full Server Certificate Chain Not Sent to cli

Re: [BUGS] BUG #5468: Pg doesn't send accepted root CA list to client during SSL client cert request

2010-05-26 Thread Craig Ringer
On 27/05/10 10:05, Tom Lane wrote: Craig Ringer writes: See the self-contained test case here: http://www.postnewspapers.com.au/~craig/testcase.zip Thanks for posting that; it makes it a lot easier to experiment with the behavior of the Java software stack. I've applied your patch along w

Re: [BUGS] BUG #5468: Pg doesn't send accepted root CA list to client during SSL client cert request

2010-05-26 Thread Tom Lane
Craig Ringer writes: > See the self-contained test case here: > http://www.postnewspapers.com.au/~craig/testcase.zip Thanks for posting that; it makes it a lot easier to experiment with the behavior of the Java software stack. I've applied your patch along with some hacking on libpq. As far a

Re: [BUGS] xml data type implications of no =

2010-05-26 Thread Mark Kirkwood
On 25/05/10 16:43, Mark Kirkwood wrote: Today I ran into some interesting consequences of the xml data type being without an "=" operator. One I thought I'd post here because it has a *possible* planner impact. I'm not sure it is actually a bug as such, but this seemed the best forum to post in

Re: [BUGS] BUG #5469: regexp_matches() has poor behaviour and more poor documentation

2010-05-26 Thread Robert Haas
On Wed, May 26, 2010 at 7:58 AM, Daniele Varrazzo wrote: >> I'm not sure that it's very productive to refer to the behavior of our >> code as insane.  We do document this in section 9.7.3, pretty >> explicitly: >> >> "The regexp_matches function returns all of the captured substrings >> resulting

Re: [BUGS] Query causing explosion of temp space with join involving partitioning

2010-05-26 Thread Krzysztof Nienartowicz
Hello, Thank you for the clarifications. The plan as run from the psql looks ok, also did not notice any specific locks for this particular query. Logs of the system running queries are not utterly clear, so chasing the parameters for the explosive query is not that simple (shared logs between mul

Re: [BUGS] BUG #5474: Installation

2010-05-26 Thread Kevin Grittner
"Nelson da Silva" wrote: > PostgreSQL version: 8.0.2.1 > Operating system: Windows XP That's not a supported combination: http://wiki.postgresql.org/wiki/PostgreSQL_Release_Support_Policy You should look at upgrading as soon as practicable. > An error ocurred executing the Microsoft VC

[BUGS] BUG #5475: Problem during Instalation

2010-05-26 Thread Joel Henrique
The following bug has been logged online: Bug reference: 5475 Logged by: Joel Henrique Email address: j...@cefet-al.br PostgreSQL version: 8.4.4-1 Operating system: Windows 2003 Server Description:Problem during Instalation Details: When I try to install postgres it

[BUGS] Reinicialização - Pg_Listener

2010-05-26 Thread MarceloG
Olá pessoal, no meu aplicativo, ao invés de tabelas temporárias, utilizo o pg_listener para verificar e impedir que o mesmo usuário acesse o sistema simultaneamente. Eu disparo um "notify usuario+código" e, a cada acesso, leio a tabela/ catálogo pg_listener para saber se o usuário está ou não l

[BUGS] BUG #5474: Installation

2010-05-26 Thread Nelson da Silva
The following bug has been logged online: Bug reference: 5474 Logged by: Nelson da Silva Email address: ndsfantas...@hotmail.com PostgreSQL version: 8.0.2.1 Operating system: Windows XP Description:Installation Details: An error ocurred executing the Microsoft VC++

Re: [BUGS] BUG #5469: regexp_matches() has poor behaviour and more poor documentation

2010-05-26 Thread Daniele Varrazzo
On Wed, May 26, 2010 at 4:51 AM, Robert Haas wrote: > On Mon, May 24, 2010 at 9:16 AM, Daniele Varrazzo > wrote: >> regexp_matches() has been recently discussed >> (http://archives.postgresql.org/pgsql-bugs/2010-04/msg00026.php): it is a >> setof function and as such it can drop results. >> >> Un