Re: Temp Tables

mdb002@yahoo.com (mdb) writes:
> 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.

Surely not.

In window 1:
regression=# create temp table foo (f1 int);
CREATE
regression=#

In window 2:
regression=# create temp table foo (f1 float, f2 float);
CREATE
regression=#

So I don't see a problem.  Would you give us an example of exactly what
you are doing?

            regards, tom lane