"Albe Laurenz" <all@xxxxxxxxxxxxxxxxx> 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 various scenarios. > - Wouldn't it be desirable to have some means to verify the > integrity of a table file or a whole database? SELECT * usually does reasonably well at that. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend