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
