Re: Temporary tables privileges - Mailing list pgsql-general

From Bruce Momjian
Subject Re: Temporary tables privileges
Date
Msg-id 200503111552.j2BFq5O00291@candle.pha.pa.us
Whole thread Raw
In response to Temporary tables privileges  ("Alejandro D. Burne" <alejandro.dburne@gmail.com>)
Responses Re: Temporary tables privileges  ("Alejandro D. Burne" <alejandro.dburne@gmail.com>)
List pgsql-general
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@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

pgsql-general by date:

Previous
From: "Magnus Hagander"
Date:
Subject: Re: PostgreSQL still for Linux only?
Next
From: tony
Date:
Subject: Re: PostgreSQL still for Linux only?