Re: [BUGS] BUG #3833: Index remains when table is dropped

2008-04-28 Thread Mark Kirkwood
Bruce Momjian wrote: The comment I have from Tom Lane on this patch is: band-aid solution to just one aspect of problem ... so I am afraid I am going to have to reject it. Sorry. No problem, thanks for passing along the feedback - I was primarily interested in that (as I figured th

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

2008-04-28 Thread Zdenek Kotala
Karsten Desler wrote: 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 have a sensible log entry as

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

2008-04-28 Thread Zdenek Kotala
Tom Lane wrote: My suspicion though is that you'll find that a large portion of that page is damaged; that's usually what we've seen in such cases in the past. I think, It can happen only if corruption is less then TOAST chunk size. In other case, page header or tuple header+chunk id should be

[BUGS] PB with postgresql 7.4

2008-04-28 Thread Nicolas ZABOURI
Hello, It's not a bug but I have a question for you: My server is down and all my dump aren't make. How can make for re-install the data on a new install of the server ? I don't find a forum who can speak about this ! Can you help me please? Best regards, Europe Camions Interactive Nicolas ZAB

Re: [BUGS] PB with postgresql 7.4

2008-04-28 Thread Sam Mason
On Mon, Apr 28, 2008 at 02:14:17PM +0200, Nicolas ZABOURI wrote: > My server is down and all my dump aren't make. > How can make for re-install the data on a new install of the server ? If you can get another copy of 7.4 installed that's built for the same processor as the database was originally