Re: 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