They can also be set to drop with ON COMMIT DROP, this way they
disappear after the tranaction is commited.
I use them in this way on my web server to sort file listings, and it
works well since each apache DSO connection gets one connection to the
database.
Tony
http://www.amsoftwaredesign.com
Home of PG Lightning Admin (PGLA)
Sean Davis wrote:
>
> Temporary tables are not per-user, but per-connection. A user can be
> connected twice, but a temporary table created on one connection is
> not visible from the other connection. Also, temporary tables are
> temporary--they disappear after the connection is closed.
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
>