Re: [BUGS] Bug #777: postgresql desconectado (not connect)

2002-09-23 Thread tomas
> José Alberto Torres ([EMAIL PROTECTED]) reports a bug with a severity of 1 > The lower the number the more severe it is. > > Short Description > postgresql desconectado (not connect) > > Long Description > I'm not English. I'm Spanish, please... [...] I'll try to tackle this one with my littl

Re: [BUGS] Server hangs on multiple connections

2002-09-23 Thread David Christian
I think you've fixed it. With your patch, and a simple $ ./configure $ make $ make check # make install the check works and all tests (except geometry on floating point stuff) pass; and after installing, I can really hammer the server and it doesn't hang. Looks like users on Yellow Dog Linux

[BUGS] Bug #779: query 'SELECT '{1,2}' *= NULL' crash backend

2002-09-23 Thread pgsql-bugs
Vadim Passynkov ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description query 'SELECT '{1,2}' *= NULL' crash backend Long Description SELECT version(); version -

Re: [BUGS] Bug #779: query 'SELECT '{1,2}' *= NULL' crash backend

2002-09-23 Thread Tom Lane
[EMAIL PROTECTED] writes: > query 'SELECT '{1,2}' *= NULL' crash backend The functions defined by the contrib/array module should all be marked strict. But they were not in 7.2 :-(. Current sources have, for example, create or replace function array_texteq(_text, text) returns bool as 'MODUL

[BUGS] numeric type conversions

2002-09-23 Thread Ruslan A Dautkhanov
Hi, I should cast field of 'text' type to the 'numeric' type, but PG output error message: "ERROR: Cannot cast type 'text' to 'numeric'". I had tried to use conversion to type 'float' and all works good, and now I must write quaries like next one: SELECT price::float::numeric FROM price