Tom,
> > I'm kind of surprised that it's possible to index a temporary
> table.
> > There's not much point in doing so.
>
> Why not? You seem to be equating "temporary" with "small", but I
> don't
> see why that must be so.
Nah. I'm equating "temporary" with "query twice and throw away", which
isn't necessarily what everyone else does.
BTW, Ludwig, in postgresql versions < 7.2.0, I noticed that sometimes
indexes didn't seem to completely go away (i.e. I would get a name
conflict if I tried to drop & re-create in the same transaction)
without a VACUUM. If you're using 7.1.3, you should upgrade for this
reason.
-Josh Berkus
