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?

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026