The following bug has been logged online:

Bug reference: 1009
Logged by: Christopher Hodson
Email address: nerf-pgsql (AT) slacker (DOT) com
PostgreSQL version: 7.4
Operating system: freebsd 5.2
Description: ERROR: could not open segment 1 of relation...
Details:

I have a script that processes a bit of data. I've been working on this script since 7.2 or soa nd have had no database problems. After upgrading to 7.4 I seem to have a problem every run (which may mean calling this scripts several times).

The errors are similar to:
"psql:daily_update.sql:332: ERROR: could not open segment 1 of relation "summ_stubcount" (target block 3538944): No such file or directory"

Note that summ_stubcount is an index.

The error usually occurs within running the script the first few times and the actualy query it blows up on varies.

I'm not sure what info would be helpful here. I would be happy to provide any more information I can.

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org