Postgres dies when using an intarray operator

Поиск
Список
Период
Сортировка
От jeroen van iddekinge
Тема Postgres dies when using an intarray operator
Дата
Msg-id 1143898819.8952.19.camel@localhost.localdomain
обсуждение исходный текст
Ответы Re: Postgres dies when using an intarray operator  (Michael Fuhr <mike@fuhr.org>)
Список pgsql-hackers
Hi all,


When using intarray operator in a query, postgres dies and restart
itself when executing  the following query:


select r1.bet_sentence & r2.bet_sentence
from related r1,related r2
where r1.bet_sentence && r2.bet_sentence

the log file contains the following:

LOG:  server process (PID 14283) was terminated by signal 11
LOG:  terminating any other active server processes
LOG:  all server processes terminated; reinitializing
LOG:  database system was interrupted at 2006-04-01 15:07:04 CEST
LOG:  checkpoint record is at 1/E9178B1C
This is the only information I can find

'related' has the following definition:
   Column    |          Type          | Modifiers
--------------+------------------------+-----------id           | integer                | not nullid_line      |
integer               |id_linegroup | integer                |id_word_1    | integer                |id_word_2    |
integer               |rtype        | character varying(100) |bet_sentence | integer[]              |
 
there are about 100 000 records in this table.


The crash only happends when I create the gist index on bet_sentence:

create index ind_related_7 on related using gist ( bet_sentence gist__int_ops);


Using unbuntu 5.1 ,postgres version 8.1.3,compiled from source and intarray installed

Can someone explain this crash?


Thanks 

Jeroen



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Andrew Dunstan
Дата:
Сообщение: Re: Remote PL/Java, Summary
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: Suggestion: Which Binary?