Postgres Pro
Downloads
Home   >   mailing lists

CREATE TEMPORARY TABLE .. ON COMMIT DROP question - Mailing list pgsql-sql

From Riccardo G. Facchini
Subject CREATE TEMPORARY TABLE .. ON COMMIT DROP question
Date
Msg-id 20041119140548.37139.qmail@web13904.mail.yahoo.com
Whole thread Raw
Responses Re: CREATE TEMPORARY TABLE .. ON COMMIT DROP question
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: Richard Huxton
Date:
Subject: Re: transactions in functions, possible bug or what I'm doing
Next
From: Tom Lane
Date:
Subject: Re: CREATE TEMPORARY TABLE .. ON COMMIT DROP question