Postgres Pro
Downloads
Home   >   mailing lists

Re: Temporary tables and indexes - Mailing list pgsql-sql

From Josh Berkus
Subject Re: Temporary tables and indexes
Date
Msg-id web-1775416@davinci.ethosmedia.com
Whole thread Raw
In response to Temporary tables and indexes  (Ludwig Lim <lud_nowhere_man@yahoo.com>)
Responses Re: Temporary tables and indexes
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: Charles Hauser
Date:
Subject: Re: Problems Formulating a SELECT
Next
From: "Josh Berkus"
Date:
Subject: Re: [NOVICE] update question