Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

temp tables problem


  • From: sconeek(at)gmail(dot)com
  • To: pgsql-general(at)postgresql(dot)org
  • Subject: temp tables problem
  • Date: 20 Apr 2006 20:43:52 -0700
  • Message-id: <1145591032(dot)209512(dot)258950(at)i39g2000cwa(dot)googlegroups(dot)com>

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.




Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group