6 1:12 PM
Subject: Re: [GENERAL] Why the data changes it's value by itself!
Ardian Xharra wrote:
Does this message in application.log can be the source of problem
wuaueng.dll (1204) Synchronous read page checksum error -1018 ((1:801
1:801) (0-13218) (0-14642)) occurred. Please restore t
> > Does this message in application.log can be the source of problem
> >
> > wuaueng.dll (1204) Synchronous read page checksum error
> -1018 ((1:801
> > 1:801) (0-13218) (0-14642)) occurred. Please restore the databases
> > from a previous backup.
>
> I don't recognise this as a PostgreSQL err
Ardian Xharra wrote:
Does this message in application.log can be the source of problem
wuaueng.dll (1204) Synchronous read page checksum error -1018 ((1:801
1:801) (0-13218) (0-14642)) occurred. Please restore the databases from
a previous backup.
I don't recognise this as a PostgreSQL error
chard Huxton"
To: "Ardian Xharra" <[EMAIL PROTECTED]>
Cc: "postgreSQL postgreSQL"
Sent: Friday, November 17, 2006 5:44 AM
Subject: Re: [GENERAL] Why the data changes it's value by itself!
Ardian Xharra wrote:
For the column: date(varchar 8) '2000606'
Ardian Xharra wrote:
For the column: date(varchar 8) '2000606' the
SELECT ascii(substring(date,4,1)) from jnlsale WHERE id_jnlsale=28384
gives: 22
SELECT ascii('6'); gives 54
Hmm - a difference of 32, or a single bit (2^5).
For the column: amount(float 8) 1.20932764209866e-307 the
SELECT as
sale=28382
gives: 48
regards Ardian
- Original Message -
From: "Richard Huxton"
To: "Ardian Xharra" <[EMAIL PROTECTED]>
Cc: "postgreSQL postgreSQL"
Sent: Thursday, November 16, 2006 1:47 PM
Subject: Re: [GENERAL] Why the data changes it's value
Ardian Xharra wrote:
No, sorry about the name of the table it's the same table.
Yes, the change is in live database during a select
OK, so it's definitely a data change. Can you get the numeric value of
the character in question, and compare it to the original value
SELECT ascii(substring(m
ent: 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 firs
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 table
