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
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings
