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