Re: Temporary tables privileges

Alejandro D. Burne wrote:
> Hi, I'm new at pg.
> I'll be using tmp tables in others rdbms. An user can create your own
> tmp tables (grant temporary tables) but can't drop it (I don't want to
> grant drop privileges).
> Other way it's using on commit; but I can't make this work.
>
> Example:
> CREATE TEMPORARY TABLE tmp ON COMMIT DROP AS
> SELECT code FROM mytable WHERE code BETWEEN 1 AND 10;
>
> shows error near ON

Our TODO has:

* Add ON COMMIT capability to CREATE TABLE AS SELECT

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073