Significance of numbers in server errors?

From: Sebastien Boisvert <sebastienboisvert(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Significance of numbers in server errors?
Date: 2011-03-04 23:15:23
Message-ID: 817915.66449.qm@web34301.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I'm wondering if there's a description anywhere of the significance of number
reported in errors; for example I've recently run into this error:

ERROR: could not read block 132 of relation 1663/16430/1249: read only 0 of
8192 bytes

From some documentation I've read
(http://etutorials.org/SQL/Postgresql/Part+I+General+PostgreSQL+Use/Chapter+4.+Performance/How+PostgreSQL+Organizes+Data/)
I know the second is the database's directory, the last is the pg_attribute
table (in this example), but I haven't figured out what the first is.

Additionally, is that format usually consistent across errors? For example,
would the number in this error relate to the same values:

ERROR: could not open relation 1663/16430/16868: No such file or directory

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Peter Geoghegan 2011-03-05 00:13:18 Re: Significance of numbers in server errors?
Previous Message Matt Warner 2011-03-04 22:08:14 Re: Unprivileged access to pgsql functions?