Access problems on temp tables - Mailing list pgsql-general

From Peter Eisentraut
Subject Access problems on temp tables
Date
Msg-id Pine.LNX.4.10.9907281338020.8870-100000@saxony.pathwaynet.com
Whole thread Raw
Responses Re: [GENERAL] Access problems on temp tables
List pgsql-general
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 anyway.

PostgreSQL 6.5.0 on i686-pc-linux-gnu, compiled by gcc 2.7.2.3

--
Peter Eisentraut
PathWay Computing, Inc.


pgsql-general by date:

Previous
From: Herouth Maoz
Date:
Subject: Re: [GENERAL] int2/int4 Failure with 6.5.1 and SlackWare 4.0
Next
From: Bruce Momjian
Date:
Subject: Re: [GENERAL] Access problems on temp tables