Re: [GENERAL] Undetected corruption of table files

2007-08-27 Thread Gregory Stark
"Tom Lane" <[EMAIL PROTECTED]> writes: > "Albe Laurenz" <[EMAIL PROTECTED]> writes: >> Tom Lane wrote: Would it be an option to have a checksum somewhere in each data block that is verified upon read? > >>> That's been proposed before and rejected before. See the archives ... > >> I sea

Re: [GENERAL] Undetected corruption of table files

2007-08-27 Thread Tom Lane
"Albe Laurenz" <[EMAIL PROTECTED]> writes: > Tom Lane wrote: >>> Would it be an option to have a checksum somewhere in each >>> data block that is verified upon read? >> That's been proposed before and rejected before. See the archives ... > I searched for "checksum" and couldn't find it. Could

Re: [GENERAL] Undetected corruption of table files

2007-08-27 Thread Albe Laurenz
Tom Lane wrote: >> Would it be an option to have a checksum somewhere in each >> data block that is verified upon read? > > That's been proposed before and rejected before. See the archives ... I searched for "checksum" and couldn't find it. Could someone give me a pointer? I'm not talking about

Re: [GENERAL] Undetected corruption of table files

2007-08-24 Thread Tom Lane
"Albe Laurenz" <[EMAIL PROTECTED]> writes: > Would it be an option to have a checksum somewhere in each > data block that is verified upon read? That's been proposed before and rejected before. See the archives ... regards, tom lane ---(end of bro

Re: [GENERAL] Undetected corruption of table files

2007-08-24 Thread Albe Laurenz
Tom Lane wrote: >> - Shouldn't there be an error, some kind of 'missing magic >> number' or similar, when a table file consists of only >> zeros? > > The particular case of an all-zeroes page is specifically allowed, > and has to be because it's a valid transient state in various > scenarios.

Re: [GENERAL] Undetected corruption of table files

2007-08-23 Thread Tom Lane
"Albe Laurenz" <[EMAIL PROTECTED]> writes: > - Shouldn't there be an error, some kind of 'missing magic > number' or similar, when a table file consists of only > zeros? The particular case of an all-zeroes page is specifically allowed, and has to be because it's a valid transient state in var