Re: [HACKERS] Postgres dies when using an intarray operator

2006-04-03 Thread Teodor Sigaev
Fixed in cvs for 7.4-8.2 releases. Michael Fuhr wrote: On Sat, Apr 01, 2006 at 03:40:19PM +0200, jeroen van iddekinge wrote: 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,r

Re: [HACKERS] Postgres dies when using an intarray operator

2006-04-01 Thread Tom Lane
Michael Fuhr <[EMAIL PROTECTED]> writes: > Here's a complete test case: > CREATE TABLE foo (a integer[]); > INSERT INTO foo (a) > SELECT array[random() * 10, random() * 10, random() * 10] > FROM generate_series(1, 24); > CREATE INDEX foo_a_idx ON foo USING gist (a gist__int_ops); > SET enab

Re: [HACKERS] Postgres dies when using an intarray operator

2006-04-01 Thread Michael Fuhr
[Please copy the mailing list on replies.] On Sat, Apr 01, 2006 at 07:20:57PM +0200, jeroen van iddekinge wrote: > > TRAP: BadArgument("!(((header->context) != ((void *)0) && > > (Node*)((header->context)))->type) == T_AllocSetContext", File: > > "mcxt.c", Line: 612) > > > > I started

Re: [HACKERS] Postgres dies when using an intarray operator

2006-04-01 Thread Michael Fuhr
On Sat, Apr 01, 2006 at 03:40:19PM +0200, jeroen van iddekinge wrote: > 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_sente

[HACKERS] Postgres dies when using an intarray operator

2006-04-01 Thread jeroen van iddekinge
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 14