Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #5784: CREATE INDEX USING GIN complains about array containing null values yet none exist - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #5784: CREATE INDEX USING GIN complains about array containing null values yet none exist
Date
Msg-id 26122.1291567379@sss.pgh.pa.us
Whole thread Raw
In response to Re: BUG #5784: CREATE INDEX USING GIN complains about array containing null values yet none exist  (Andres Freund <andres@anarazel.de>)
Responses Re: BUG #5784: CREATE INDEX USING GIN complains about array containing null values yet none exist  (Andres Freund <andres@anarazel.de>)
List pgsql-bugs
Tree view 
Andres Freund <andres@anarazel.de> writes:
>> On Sunday 05 December 2010 13:07:23 Martin Atukunda wrote:
>>>> so, basically, the only way out of this would be to:

I think the reason the given example fails is just that it's all being
done in one transaction.  If the null-containing row were known dead
it wouldn't get indexed.  So: commit.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Andres Freund
Date:
Subject: Re: BUG #5784: CREATE INDEX USING GIN complains about array containing null values yet none exist
Next
From: Andres Freund
Date:
Subject: Re: BUG #5784: CREATE INDEX USING GIN complains about array containing null values yet none exist