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 5nd0c0tp982ufa2ipgh70ej8169jbfl8tb@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 11:23:30 +0200, "Nagib Abi Fadel"
<nagib.abi-fadel@usj.edu.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

pgsql-general by date:

Previous
From: Karel Zak
Date:
Subject: Re: [HACKERS] Slony-I goes BETA
Next
From: Mike Mascari
Date:
Subject: Re: Creating a session variable in Postgres