Re: [GENERAL] Access problems on temp tables

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: [GENERAL] Access problems on temp tables
Дата
Msg-id 199907281809.OAA14611@candle.pha.pa.us
обсуждение исходный текст
Ответ на Access problems on temp tables  (Peter Eisentraut <peter@pathwaynet.com>)
Список 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
>

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

В списке pgsql-general по дате отправления:

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Access problems on temp tables
Следующее
От: Randy Dees
Дата:
Сообщение: Re: [GENERAL] Problems importing my 6.3 database into 6.5.1