Wait i did the following test:
SELECT count(*) from pg_class ;
count
-------
894
SELECT count(*) from pg_attribute ;
count
-------
7264
CREATE temp table temp_test (id integer);
CREATE TABLE
SELECT count(*) from pg_class ;
count
-------
895
SELECT count(*) from pg_attribute ;
count
-------
7272
I DISCONNECTED AND RECONNECTED TO THE DATABASE:
NOW
SELECT count(*) from pg_class ;
count
-------
894
SELECT count(*) from pg_attribute ;
count
-------
7264
According to those results the meta_data for a temp table are automatically
removed when the table is destroyed
So ........
----- Original Message -----
From: "Nagib Abi Fadel" <nagib.abi-fadel@usj.edu.lb>
To: "Manfred Koizar" <mkoi-pg@aon.at>
Cc: "Mike Mascari" <mascarm@mascari.com>; "Bruce Momjian"
<pgman@candle.pha.pa.us>; "generalpost" <pgsql-general@postgresql.org>
Sent: Friday, June 04, 2004 11:14 AM
Subject: Re: [GENERAL] Creating a session variable in Postgres
> So considering those facts, it would be better to use the Sequence Method,
> since it would only require cleaning up one table ....
> Or is there anything else i am missing ???
>
>
> ----- Original Message -----
> From: "Manfred Koizar" <mkoi-pg@aon.at>
> To: "Nagib Abi Fadel" <nagib.abi-fadel@usj.edu.lb>
> Cc: "Mike Mascari" <mascarm@mascari.com>; "Bruce Momjian"
> <pgman@candle.pha.pa.us>; "generalpost" <pgsql-general@postgresql.org>
> Sent: Friday, June 04, 2004 08:32 AM
> Subject: Re: [GENERAL] Creating a session variable in Postgres
>
>
> > On Fri, 4 Jun 2004 08:25:38 +0200, "Nagib Abi Fadel"
> > <nagib.abi-fadel@usj.edu.lb> wrote:
> > >The use of sequence would require to clean up the table every N hour .
> >
> > Right.
> >
> > >The use of temporary table wouldn't require any cleanup.
> >
> > Wrong. You would have to clean up the meta data, at least pg_class and
> > pg_attribute, maybe pg_index also. For the price of one temp table you
> > can have several rows in a permanent table.
> >
> > Servus
> > Manfred
>
