CREATE TEMPORARY TABLE .. ON COMMIT DROP question

From: "Riccardo G(dot) Facchini" <abief_ag_-postgresql(at)yahoo(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: CREATE TEMPORARY TABLE .. ON COMMIT DROP question
Date: 2004-11-19 14:05:47
Message-ID: 20041119140548.37139.qmail@web13904.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi all,

I'm trying to understand where the "[ ON COMMIT { PRESERVE ROWS |
DELETE ROWS | DROP } ]" is stored when defining a temporary table.

whenever a table is created, a record in the pg_class is stored with
the info regarding the table, but I haven't been able to locate where
the info regarding these particular parameters is stored.

any suggestion?

regards,

Riccardo

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2004-11-19 15:08:15 Re: CREATE TEMPORARY TABLE .. ON COMMIT DROP question
Previous Message Richard Huxton 2004-11-19 12:59:07 Re: transactions in functions, possible bug or what I'm doing