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
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? |