"Albe Laurenz" <all(at)adv(dot)magwien(dot)gv(dot)at> 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