temp tables problem
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.
just to add on that, there is only one user for the db. so both
application accesses use the same db username and password. the web app
automatically logs into the db in with the one username and password
for both remote and local access.
On Thu, Apr 20, 2006 at 09:21:27PM -0700, sconeek@gmail.com wrote:
just to add on that, there is only one user for the db. so both
application accesses use the same db username and password. the web app
automatically logs into the db in with the one username and password
for both remote and local access.
Users don't matter at all for temp tables. Temp tables are per
*session*, so as soon as you come in from a different connection it's a
different set of temp tables.
--
Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461