Re: [BUGS] Out of memory

2003-07-09 Thread Stephan Szabo
On Tue, 8 Jul 2003, Ivan Boscaino wrote: > Hi, > I'm not sure if you know this problem. > > Create an empty function with 26 parameters: > > create function test (INTEGER,TEXT,TEXT,TEXT,CHAR(16),CHAR(11), > BOOLEAN,BOOLEAN,BOOLEAN,BOOLEAN,BOOLEAN,BOOLEAN, > BOOLEAN,BOOLEAN,BOOLEAN,CHAR(2),TEXT,TE

Re: [BUGS] Precision errors in float8 type casting (as of 7.3.2 and

2003-07-09 Thread Stephan Szabo
On Wed, 9 Jul 2003, Philip Edelbrock wrote: > phil=# select (3.85::float4)::float8; > float8 > -- > 3.8490463257 > (1 row) > > (Or substitute 3.85 for any number with something other than 0 to the > right of the decimal point, or pull the same values from any table whic

Re: [BUGS] case sensitivity

2003-07-09 Thread Shachar Shemesh
Stephan Szabo wrote: On Sun, 6 Jul 2003, Shachar Shemesh wrote: Tom Lane wrote: See also the example and footnote at the end of section 1.1.1 of our documentation: http://www.postgresql.org/docs/view.php?version=7.3&idoc=0&file=sql-syntax.html#SQL-SYNTAX-IDENTIFIERS (not sure why the lin

[BUGS] Precision errors in float8 type casting (as of 7.3.2 and some earlierreleases at least)

2003-07-09 Thread Philip Edelbrock
I ran into this oddity today and tested it on a few of our PosgreSQL backends (all of which gave the same response): phil=# select 3.85::float4*1; ?column? -- 3.8490463257 (1 row) phil=# select 3.85::float4*1::float8; ?column? -- 3.849046

[BUGS] pg_tables view definition incorrect??

2003-07-09 Thread Mike Quinn
version --- PostgreSQL 7.3.2 on i586-pc-linux-gnu, compiled by GCC 2.95.3 (1 row) View "pg_catalog.pg_tables" Column| Type | Modifiers -+-+---

[BUGS] Out of memory

2003-07-09 Thread Ivan Boscaino
Hi, I'm not sure if you know this problem. Create an empty function with 26 parameters: create function test (INTEGER,TEXT,TEXT,TEXT,CHAR(16),CHAR(11), BOOLEAN,BOOLEAN,BOOLEAN,BOOLEAN,BOOLEAN,BOOLEAN, BOOLEAN,BOOLEAN,BOOLEAN,CHAR(2),TEXT,TEXT,TEXT,TEXT, CHAR(5),TEXT,TEXT,TEXT,TEXT,TEXT ) returns i

[BUGS] Error: Panic

2003-07-09 Thread Sociedad Literaria METAFORA
Hi folks. I have Postgresql running with Freeside. Yesterday I got this error. Someone can give me some light about the subject, please? POSTGRESQL BUG REPORT TEMPLATE =

[BUGS] psql linked to openssl 0.9.6 _and_ 0.9.7 shared libs

2003-07-09 Thread Walter Haidinger
Hi! I've built 7.3.3 under Solaris 2.6 using gcc 2.95.3 and GNU ld. Compilation and the regression tests are all successful. However, I've installed OpenSSL 0.9.7b _and_ have an older 0.9.6 version some programs still depend on (recompiling is on my todo list, though). While the backend is corre