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

[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

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_sentence

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 the postmaster

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