Stefan Kaltenbrunner wrote:
> Gregory Stark wrote:
>> "Joe Conway" <mail@joeconway.com> writes:
>>
>>> psql:/home/jconway/pgsql/das_data_load_failure2.sql:419: PANIC: failed
>>> to add item to the left sibling for "pk_status_log_2007_01_4_10"
>> Was this preceded by a WARNING?
>>
>> Was the server running with a log_min_messages low enough to log WARNINGs?
>>
>> I probably can't help find the bug but I can see that would be helpful as
>> there are three branches of the code that can result in this and two of them
>> log warnings before returning the invalid offset which causes the panic.
>
> FWIW I can reproduce the crash on 8.2 and I don't get a WARNING either ...

I don't get the WARNING, and I'm using stock default postgresql.conf.

Joe


---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match