Re: [HACKERS] problem inserting in GIN index

2009-03-10 Thread Alvaro Herrera
Emanuel Calvo Franco escribió: > 2009/3/10 Teodor Sigaev : > >> Apparently there's a crash involved ... > > > > Are other indexes on that table broken? ( Just count(*) with only index scan > > enabled ) > Yes, there are some btree indexes broken. > Alvaro asked him if the option fsync is off. We

Re: [HACKERS] problem inserting in GIN index

2009-03-10 Thread Emanuel Calvo Franco
2009/3/10 Teodor Sigaev : >> Apparently there's a crash involved ... > > Are other indexes on that table broken? ( Just count(*) with only index scan > enabled ) > -- > Teodor Sigaev                                   E-mail: teo...@sigaev.ru >                                                   WWW:

Re: [HACKERS] problem inserting in GIN index

2009-03-10 Thread Teodor Sigaev
Apparently there's a crash involved ... Are other indexes on that table broken? ( Just count(*) with only index scan enabled ) -- Teodor Sigaev E-mail: teo...@sigaev.ru WWW: http://www.sigaev.ru/ -- Sent via

Re: [HACKERS] problem inserting in GIN index

2009-03-10 Thread Teodor Sigaev
A guy just reported on pgsql-es-ayuda that he's getting ERROR: item pointer (543108,2) already exists It will be fine to get test case... Apparently this message only occurs on GIN, in insertItemPointer Reading that routine I can

Re: [HACKERS] problem inserting in GIN index

2009-03-09 Thread Emanuel Calvo Franco
2009/3/9 Alvaro Herrera : > Tom Lane wrote: >> Alvaro Herrera writes: >> > A guy just reported on pgsql-es-ayuda that he's getting >> > ERROR: item pointer (543108,2) already exists >> Test case? > > Apparently there's a crash involved ... > I asked to Gabriel. The exactly version is 8.3.6. He ju

Re: [HACKERS] problem inserting in GIN index

2009-03-09 Thread Alvaro Herrera
Tom Lane wrote: > Alvaro Herrera writes: > > A guy just reported on pgsql-es-ayuda that he's getting > > ERROR: item pointer (543108,2) already exists > > > Test case? Apparently there's a crash involved ... -- Alvaro Herrera

Re: [HACKERS] problem inserting in GIN index

2009-03-09 Thread Tom Lane
Alvaro Herrera writes: > A guy just reported on pgsql-es-ayuda that he's getting > ERROR: item pointer (543108,2) already exists > Test case? regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-

[HACKERS] problem inserting in GIN index

2009-03-09 Thread Alvaro Herrera
Hi, A guy just reported on pgsql-es-ayuda that he's getting ERROR: item pointer (543108,2) already exists Apparently this message only occurs on GIN, in insertItemPointer Reading that routine I cannot help but wonder -- where is g