Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-sql by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group