temp tables problem

From: sconeek(at)gmail(dot)com
To: pgsql-general(at)postgresql(dot)org
Subject: temp tables problem
Date: 2006-04-21 03:43:52
Message-ID: 1145591032.209512.258950@i39g2000cwa.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

hi all,
i am working on a java based web application. this application connects
to a postgres DB.

now within some pages i am using temp tables to perform some
calculation. when i access these pages locally it works fine. however
when i access the web app remotely (as in over the web or on the
network) those pages fail with an exception saying that, the temp table
already exists.

those tables work fine when i access the web app locally as many times
as i want. but if i access the same page remotely at the same time, it
fails and vice versa too.

i was hoping that temp tables would fix this problem (two users
performing the same calculation at the same time, one locally and one
remotely), but it seems to not work.

can somebody please help me out. thanks heaps.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message sconeek 2006-04-21 04:21:27 Re: temp tables problem
Previous Message Tom Lane 2006-04-21 02:44:54 Re: sudo-like behavior