Re: [BUGS] B-tree crash recovery error in 8.3 beta 2

2007-11-16 Thread Tom Lane
Heikki Linnakangas <[EMAIL PROTECTED]> writes: > There seems to be a bug in the B-tree split WAL reduction patch from > Februrary. On split, we copy the HIKEY of the left page from the > leftmost item on the right page, but that doesn't work because the > leftmost key is not stored on intermediate

[BUGS] B-tree crash recovery error in 8.3 beta 2

2007-11-16 Thread Koichi Suzuki
Hi, I've found that B-tree crash recovery in 8.3 beta2 could make some tuples invisible through B-tree. They're visible if we read using but Seq-Scan. This happens in 8.3 beta2, but not in 8.2.4. Here's how it happens. 1. Create b-tree for a text type column. 2. Make B-tree three-story, that

Re: [BUGS] B-tree crash recovery error in 8.3 beta 2

2007-11-16 Thread Heikki Linnakangas
Koichi Suzuki wrote: > I've found that B-tree crash recovery in 8.3 beta2 could make some > tuples invisible through B-tree. They're visible if we read using but > Seq-Scan. This happens in 8.3 beta2, but not in 8.2.4. Here's how it > happens. > > 1. Create b-tree for a text type column. > 2.

[BUGS] B-tree crash recovery error in 8.3 beta 2

2007-11-15 Thread Koichi Suzuki
Hi, I've found that B-tree crash recovery in 8.3 beta2 could make some tuples invisible through B-tree. They're visible if we read using but Seq-Scan. This happens in 8.3 beta2, but not in 8.2.4. Here's how it happens. 1. Create b-tree for a text type column. 2. Make B-tree three-story, that