Lukasz Brodziak <lukasz.brodziak@xxxxxxxxx> writes: > One question about blocks in PG. I got an error "Could not read block > <no.> of relation...." it appeared to be in pg_trigger but the thing > is that the block number was 110 and the file has only 67 pages. So > the question is how is it possible? Well, that's why it failed to read the block ;-). The real question is why was it trying to read a block that doesn't exist in the table. I'd bet on a corrupt index myself, so try reindexing. regards, tom lane -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
