| 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: | Whole Thread | Raw Message | 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? |