No, sorry about the name of the table it's the same table.
Yes, the change is in live database during a select
Regards, Ardian
----- Original Message -----
From: "Richard Huxton" <dev@xxxxxxxxxxxx>
To: "Ardian Xharra" <axharra@xxxxxxxxxx>
Cc: "postgreSQL postgreSQL" <pgsql-general@xxxxxxxxxxxxxx>
Sent: Thursday, November 16, 2006 12:30 PM
Subject: Re: [GENERAL] Why the data changes it's value by itself!
Ardian Xharra wrote:
Hello,
We been having a problem lately with some data changing their value
without modifying them.
We used to backups to see the difference:
this was the first backup
INSERT INTO journal VALUES
and the second backup
INSERT INTO jnlsale VALUES
These are different tables. Do you have an example which shows data
changing?
Does it change in the live database if you select data out?
Version used PostgreSQl 8.1.1 on Windows box with Windows 2000 server
Upgrade to 8.1.5 as soon as is convenient.
--
Richard Huxton
Archonet Ltd
--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.1.409 / Virus Database: 268.14.6/535 - Release Date: 15/11/2006
