Re: Creating a session variable in Postgres - Mailing list pgsql-general

From Manfred Koizar
Subject Re: Creating a session variable in Postgres
Date
Msg-id pc50c0dah4hcqdls42ec14ggi42uahkg9b@email.aon.at
Whole thread Raw
In response to Re: Creating a session variable in Postgres  ("Nagib Abi Fadel" <nagib.abi-fadel@usj.edu.lb>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Manfred Koizar
Date:
Subject: Re: Creating a session variable in Postgres
Next
From: Tom Lane
Date:
Subject: Re: Bug Report -- information schema view is broken 'unrecognized privilege type: "RERERENCES"'