Re: [GENERAL] Strange phenomenon

2010-10-15 Thread Craig Ringer
On 10/15/2010 03:36 PM, Martial Braem wrote: 2) On day one, I store data in my application data tables and in the logging table (transactional data). At the end of the day, I extract the data from the database for daily reporting (the ultimate proof that the transactions are actually committed).

Re: [GENERAL] Strange phenomenon

2010-10-15 Thread Joshua J. Kugler
On Friday 15 October 2010, Scott Marlowe elucidated thus: > On Fri, Oct 15, 2010 at 12:37 PM, Tom Lane wrote: > > I'd look around for a cron job or some other periodic task that > > thinks it's supposed to reload the database or something like that. > > Ā Postgres doesn't forget stuff that easily .

Re: [GENERAL] Strange phenomenon

2010-10-15 Thread Scott Marlowe
On Fri, Oct 15, 2010 at 12:37 PM, Tom Lane wrote: > > I'd look around for a cron job or some other periodic task that thinks > it's supposed to reload the database or something like that. Ā Postgres > doesn't forget stuff that easily ... unless it's told to. Had a search engine eat an entire datab

Re: [GENERAL] Strange phenomenon

2010-10-15 Thread Tom Lane
"Martial Braem" writes: > Recently I observed a strange phenomenon: > 1) The database has some tables where I store my application data. > I have an additional table, with no relation to any other table, just > for logging purposes. In the database, a sequence is defined too. > 2) On day

Re: [GENERAL] Strange phenomenon

2010-10-15 Thread Szymon Guz
On 15 October 2010 09:36, Martial Braem wrote: > Hi, > > > > I am a Java developer, using PostgreSQL as a database. > > Recently I observed a strange phenomenon: > > 1) The database has some tables where I store my application data. I > have an additional table, with no relation to any othe

[GENERAL] Strange phenomenon

2010-10-15 Thread Martial Braem
Hi, I am a Java developer, using PostgreSQL as a database. Recently I observed a strange phenomenon: 1) The database has some tables where I store my application data. I have an additional table, with no relation to any other table, just for logging purposes. In the database, a sequence is d