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.