Re: temp tables

Is this safe?  What happens if multiple users hit the PHP page nearly simultaneously (or at least just after someone else) and the temp table exists?  I avoided the temp table approach in an app for exactly this reason...  What does PG do in this case?  Do the temp tables belong to the session/connection and they're insulated from each other?

Thanks,

Bret


> -----Original Message-----
> From: pgsql-novice-owner@postgresql.org 
> [mailto:pgsql-novice-owner@postgresql.org] On Behalf Of John DeSoi
> Sent: Thursday, April 28, 2005 8:18 AM
> To: Cima
> Cc: PostgreSQL Novice
> Subject: Re: [NOVICE] temp tables
> 
> 
> On Apr 28, 2005, at 12:45 AM, Cima wrote:
> 
> >
> > im working with php 4 and postgresql 8 and in my php script 
> id like to 
> > create a temp table on my database server. how do i do 
> this? how do i 
> > verify it was created?
> >  
> > i tried the following:
> >  
> > $sql = "create temp table s_info(a int, b text) on commit 
> delete rows 
> > ";
> >  
> > pg_query($dbh,$sql);
> >  
> >  
> > $dbh is my connection.
> >  
> > any help will be highly appreciated.
> 
> 
> You can verify it was created by checking the result from 
> pg_query and looking at pg_last_error. The table is 
> automatically dropped at the end of the connection, most 
> likely when your PHP script ends.
> 
> 
> John DeSoi, Ph.D.
> http://pgedit.com/
> Power Tools for PostgreSQL
> 
> 
> ---------------------------(end of 
> broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
>       subscribe-nomail command to majordomo@postgresql.org so 
> that your
>       message can get through to the mailing list cleanly
>