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