| From: | Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us> |
|---|---|
| To: | Peter Eisentraut <peter(at)pathwaynet(dot)com> |
| Cc: | pgsql-general(at)postgreSQL(dot)org, pgsql-admin(at)postgreSQL(dot)org |
| Subject: | Re: [GENERAL] Access problems on temp tables |
| Date: | 1999-07-28 18:09:38 |
| Message-ID: | 199907281809.OAA14611@candle.pha.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Randy Dees | 1999-07-28 21:28:24 | Re: [GENERAL] Problems importing my 6.3 database into 6.5.1 |
| Previous Message | Peter Eisentraut | 1999-07-28 17:43:03 | Access problems on temp tables |