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.
