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.