| From: | Tony Caduto <tony_caduto(at)amsoftwaredesign(dot)com> |
|---|---|
| To: | Sean Davis <sdavis2(at)mail(dot)nih(dot)gov> |
| Cc: | Zlatko Matic <zlatko(dot)matic1(at)sb(dot)t-com(dot)hr>, pgsql list <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: temporary tables ? |
| Date: | 2005-07-22 18:17:01 |
| Message-ID: | 42E1381D.8040302@amsoftwaredesign.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | diego ayala torres | 2005-07-22 18:34:11 | transportar base de datos |
| Previous Message | Sean Davis | 2005-07-22 18:06:22 | Re: temporary tables ? |