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" <[EMAIL PROTECTED]>
To: "Nagib Abi Fadel" <[EMAIL PROTECTED]>
Cc: "Mike Mascari" <[EMAIL PROTECTED]>; "Bruce Momjian"
<[EMAIL PROTECTED]>; "generalpost" <[EMAIL PROTECTED]>
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"
> <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
