Re: Creating a session variable in Postgres

From: Manfred Koizar <mkoi-pg(at)aon(dot)at>
To: "Nagib Abi Fadel" <nagib(dot)abi-fadel(at)usj(dot)edu(dot)lb>
Cc: "Mike Mascari" <mascarm(at)mascari(dot)com>, "Bruce Momjian" <pgman(at)candle(dot)pha(dot)pa(dot)us>, "generalpost" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Creating a session variable in Postgres
Date: 2004-06-04 06:32:18
Message-ID: pc50c0dah4hcqdls42ec14ggi42uahkg9b@email.aon.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, 4 Jun 2004 08:25:38 +0200, "Nagib Abi Fadel"
<nagib(dot)abi-fadel(at)usj(dot)edu(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2004-06-04 06:45:32 Re: Bug Report -- information schema view is broken 'unrecognized privilege type: "RERERENCES"'
Previous Message Nagib Abi Fadel 2004-06-04 06:25:38 Re: Creating a session variable in Postgres