[GENERAL] int2/int4 Failure with 6.5.1 and SlackWare 4.0

1999-07-28 Thread Charles Tassell
Hi there, When running the regression tests for Postgres 6.5.1 on my SlackWare 4.0 box, I received an error on the int2 and int4 types. Here's what was in the regress.out file: text .. ok strings .. ok int2 .. failed int4 .. failed int8 .. ok oid .. ok float4 .. ok float8 .. ok Here is the

Re: [GENERAL] int2/int4 Failure with 6.5.1 and SlackWare 4.0

1999-07-28 Thread Herouth Maoz
At 19:16 +0300 on 28/07/1999, Charles Tassell wrote: > Here is the error from int2.out: > > QUERY: CREATE TABLE INT2_TBL(f1 int2); > QUERY: INSERT INTO INT2_TBL(f1) VALUES ('0'); > QUERY: INSERT INTO INT2_TBL(f1) VALUES ('1234'); > QUERY: INSERT INTO INT2_TBL(f1) VALUES ('-1234'); > QUERY: INSER

Re: [GENERAL] Problems importing my 6.3 database into 6.5.1

1999-07-28 Thread Randy Dees
On Wed, Jul 28, 1999, Herouth Maoz boldly stated > No way to get around it. You have to change the name of the field in the > create statement (and all the queries that use it), or put it in double > quotes (and do the same in all the queries). > > While you are at it, do a thorough search for al

[GENERAL] Access problems on temp tables

1999-07-28 Thread Peter Eisentraut
A relatively unprivileged user enters: => create temp table foobar (foo text); CREATE => insert into foobar values ('Hi'); ERROR: pg_temp.13251.2: Permission denied. I've also tried to grant on the table, but this strikes me as weird since I created the table and I should have all access to it

Re: [GENERAL] Access problems on temp tables

1999-07-28 Thread Bruce Momjian
> A relatively unprivileged user enters: > > => create temp table foobar (foo text); > CREATE > => insert into foobar values ('Hi'); > ERROR: pg_temp.13251.2: Permission denied. > > I've also tried to grant on the table, but this strikes me as weird since > I created the table and I should have