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 08:48:02
Message-ID: 5nd0c0tp982ufa2ipgh70ej8169jbfl8tb@email.aon.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, 4 Jun 2004 11:23:30 +0200, "Nagib Abi Fadel"
<nagib(dot)abi-fadel(at)usj(dot)edu(dot)lb> wrote:
>According to those results the meta_data for a temp table are automatically
>removed when the table is destroyed

Yes, but the dead tuples remain. Try

VACUUM VERBOSE pg_class;
VACUUM VERBOSE pg_attribute;

Servus
Manfred

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Nagib Abi Fadel 2004-06-04 09:14:09 Re: Creating a session variable in Postgres
Previous Message Karel Zak 2004-06-04 08:47:26 Re: [HACKERS] Slony-I goes BETA