Temporary tables privileges

From: "Alejandro D(dot) Burne" <alejandro(dot)dburne(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Temporary tables privileges
Date: 2005-03-09 17:11:33
Message-ID: 8398dc6d05030909111f6c2b6d@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Thanks. Alejandro.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joshua D. Drake 2005-03-09 17:14:02 Re: PostgreSQL still for Linux only?
Previous Message Jim C. Nasby 2005-03-09 17:02:10 Re: PostgreSQL still for Linux only?