Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: CREATE TEMPORARY TABLE .. ON COMMIT DROP question
Date
Msg-id 27902.1100876895@sss.pgh.pa.us
Whole thread Raw
In response to CREATE TEMPORARY TABLE .. ON COMMIT DROP question  ("Riccardo G. Facchini" <abief_ag_-postgresql@yahoo.com>)
Responses Re: CREATE TEMPORARY TABLE .. ON COMMIT DROP question
List pgsql-sql
Tree view 
"Riccardo G. Facchini" <abief_ag_-postgresql@yahoo.com> writes:
> I'm trying to understand where the "[ ON COMMIT { PRESERVE ROWS |
> DELETE ROWS | DROP } ]" is stored when defining a temporary table.

I don't believe it's stored anyplace visible :-(.  There's some private
state in the memory of the backend that owns the table.  Look into
commands/tablecmds.c.
        regards, tom lane

pgsql-sql by date:

Previous
From: "Riccardo G. Facchini"
Date:
Subject: CREATE TEMPORARY TABLE .. ON COMMIT DROP question
Next
From: "Riccardo G. Facchini"
Date:
Subject: Re: CREATE TEMPORARY TABLE .. ON COMMIT DROP question