Re: Temp Tables

mdb002(at)yahoo(dot)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