Re: Temp Tables

> mdb wrote:
> > Hello,
> >
> > I am running a client server app and am using temp tables to do some
> > data manipulation.  However, Postgresql seems to prevent multiple temp
> > tables from being created with the same name.  The temp tables are
> > created by seperate connections to the database, but this does not
> > seem to matter.  Is this correct?  Do I need to make the names unique
> > by using a user id?  Am I doing something wrong?  I am using
> > Postgresql 7.1.3 and odbc 7.1.9.
>
> Temp tables can be created with identical names in different
> connections.  I have no idea why it is failing.  Are you trying to
> create the same temp table in the same session?  Could you show us the
> failure?
>

I believe (and I'm no expert) that the table names must be unique by user so
if your client/server app uses the same generic user name (like your web
server's user for example), I don't think the particular session matters.
It's a user_name+temp_table_name thing.

But I could be wrong.  :-)

Len Morgan