Jo De Haes <jo.de_nospam_haes@indicator.be> writes:
> I asked the developper to delete all imported data again an restart the
> import. This import crashed again with the same error but this time on
> another block.
> 2006-03-27 00:15:25.458 CESTERROR: XX001: invalid page header in block
> 48068 of relation "dunn_main"
> 2006-03-27 00:15:25.458 CESTCONTEXT: SQL statement "SELECT phone FROM
> dunn_main WHERE source_id = $1 AND duns = $2 "
> PL/pgSQL function "proc_dunn" line 29 at select into variables
> 2006-03-27 00:15:25.458 CESTLOCATION: ReadBuffer, bufmgr.c:257
> 2006-03-27 00:15:25.458 CESTSTATEMENT: SELECT proc_dunn ('J M
> Darby','TA4 3BU','215517942','1','01','S',NULL,'0219',156,1
> 54,387166)
> But again, when i do the 'SELECT proc_dunn ('J M Darby','TA4
> 3BU','215517942','1','01','S',NULL,'0219',156,1
> 54,387166)' statement now, it works without errors.
That is *really* strange. Are you certain that the function is
examining the same table you are? I'm wondering about multiple
similarly-named tables in different schemas, or something like that.
> If I would like to dump block 48068 now with pg_dumpfile, how do i know
> which file this block belongs to?
See
http://www.postgresql.org/docs/8.1/static/storage.html
and/or use contrib/oid2name.
regards, tom lane