Re: Temporary tables and indexes

From: "Josh Berkus" <josh(at)agliodbs(dot)com>
To: Ludwig Lim <lud_nowhere_man(at)yahoo(dot)com>, PostgreSQL Mailing List <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Temporary tables and indexes
Date: 2002-10-08 15:36:28
Message-ID: web-1775416@davinci.ethosmedia.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Ludwig,

> Are the indices of a temporary table automatically
> "dropped" together its corresponding temporary table
> after a database session?

I'm kind of surprised that it's possible to index a temporary table.
There's not much point in doing so.

Yes, the indexes would be dropped as well.

-Josh Berkus

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Josh Berkus 2002-10-08 15:39:45 Re: [NOVICE] update question
Previous Message Josh Berkus 2002-10-08 15:33:53 Re: CHAR, VARCHAR, TEXT (Was Large Databases)