Re: [SQL] CREATE TEMPORARY TABLE .. ON COMMIT DROP question

2004-11-19 Thread Riccardo G. Facchini
--- Tom Lane <__> wrote: > "Riccardo G. Facchini" <[EMAIL PROTECTED]> 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

Re: [SQL] CREATE TEMPORARY TABLE .. ON COMMIT DROP question

2004-11-19 Thread Tom Lane
"Riccardo G. Facchini" <[EMAIL PROTECTED]> 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 tha

[SQL] CREATE TEMPORARY TABLE .. ON COMMIT DROP question

2004-11-19 Thread Riccardo G. Facchini
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 regardin