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