Thread: Access problems on temp tables

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.

> 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
>

I just tried it here and it worked.

--
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026