Re: [GENERAL] Inserted data is disappearing

2009-07-10 Thread James B. Byrne
On Fri, July 10, 2009 16:20, Bill Moran wrote: > > > Also, look for a BEGIN statement that is never COMMITed. If > the client starts a transaction, INSERTs a bunch of stuff, then > disconnects without issuing a COMMIT, Postgres will rollback > the transaction, thus it will be as if the data was n

Re: [GENERAL] Inserted data is disappearing

2009-07-10 Thread Bill Moran
In response to "James B. Byrne" : > > This is a portion of the log for the most recent run that exhibits > the problem: > > ... > 2009-07-10 15:59:17 EDT hll_theheart_test 216.185.71.24(49133) > hll_theheart_db_admin : LOG: 0: duration: 0.446 ms statement: > INSERT INTO "currencies" ("is_in