Re: Corrupt database? 8.1/FreeBSD6.0

[Jeff Amiel <becauseimjeff@xxxxxxxxx>]

Tom Lane <tgl@xxxxxxxxxxxxx> wrote:

Really? Wow, *that's* an interesting thought. Is it likely that that
temp table could contain many-hour-old data?

Certainly...our connection pool used by jboss can have connections to postgres persisting for multiple days.  (We're still looking for a way to tell it to recycle these occasionally).  As each 'user' of our web based app performs some action, they acquire one of the connection pool connections and set their user_id in the temporary table used by that connection (we use that for our audit triggers)  Once they are 'done' with the connection, the connection is just released back to the pool but not actually closed...so the temp table still contains the  data from a previous
 iteration.

---

TV dinner still cooling?
Check out "Tonight's Picks" on Yahoo! TV.