[BUGS] postmaster segfault when using SELECT on a table

2008-04-26 Thread Karsten Desler
Hello, I have a smallish postgres database that segfaults everytime when I try to access a certain row in a certain column. xxx=# select file_id from dbfiles offset 632531 limit 1; server closed the connection unexpectedly This probably means the server terminated abnormally befor

Re: [BUGS] postmaster segfault when using SELECT on a table

2008-04-26 Thread Tom Lane
Karsten Desler <[EMAIL PROTECTED]> writes: > I have a smallish postgres database that segfaults everytime when I try to > access a certain row in a certain column. Looks like a corrupted-data issue to me. It might be interesting to dump the page with pg_filedump and see if there's any apparent pa

Re: [BUGS] postmaster segfault when using SELECT on a table

2008-04-26 Thread Tom Lane
Karsten Desler <[EMAIL PROTECTED]> writes: > I don't know much about the postgres architecture and I don't know if bounds > checking on-disk values on a read makes a lot of sense since usually one > should be able to assume that there are no randomly flipped bits; but it > would've been nice to hav

Re: [BUGS] postmaster segfault when using SELECT on a table

2008-04-26 Thread Karsten Desler
* Tom Lane wrote: > Karsten Desler <[EMAIL PROTECTED]> writes: > > I have a smallish postgres database that segfaults everytime when I try to > > access a certain row in a certain column. > > Looks like a corrupted-data issue to me. It might be interesting to > dump the page with pg_filedump and