BUG #2197: PostgreSQL error- 'could not read block 0 of relation'

From: Ted Clark <tootallted(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #2197: PostgreSQL error- 'could not read block 0 of relation'
Date: 2010-01-12 16:26:23
Message-ID: 93d7cfe31001120826g7fbc05b2x70f57a5cfe57c2e4@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

BUG #2197: PostgreSQL error- 'could not read block 0 of relation'

I found this bug has nothing to do with hardware. I was attemping to copy
large amounts of data from text files into tables with a primary and many
foreign keys. I found that upon truncating the tables not all key
references had been cleaned up by the database asa they had been in prior
day successful runs. After truncating all tables with a truncate table
xxxxxx cascade and then loading back into the same table, my problem was
resolved.

-Ted

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Vee 2010-01-12 22:30:32 BUG #5273: Unexpected function behavior/failure
Previous Message Dimitri Fontaine 2010-01-12 14:38:36 Re: Bug report: Wrong version in pg_config