[BUGS] BUG #5784: CREATE INDEX USING GIN complains about array containing null values yet none exist

2010-12-04 Thread Martin Atukunda
The following bug has been logged online: Bug reference: 5784 Logged by: Martin Atukunda Email address: matl...@gmail.com PostgreSQL version: 8.4 Operating system: Linux Description:CREATE INDEX USING GIN complains about array containing null values yet none exist

Re: [BUGS] BUG #5784: CREATE INDEX USING GIN complains about array containing null values yet none exist

2010-12-05 Thread Martin Atukunda
> Due to the wonders of MVCC the old row is still available in the heap. Best > read the docs about what MVCC means. And as pg's indexes don't care about > visibility it will still try to index the "old" row. > > Thanks andreas, so, basically, the only way out of this would be to: 1. copy out all

Re: [BUGS] BUG #5784: CREATE INDEX USING GIN complains about array containing null values yet none exist

2010-12-05 Thread Martin Atukunda
On Sun, Dec 5, 2010 at 7:58 PM, Andres Freund wrote: > On Sunday 05 December 2010 13:29:35 Andres Freund wrote: > > On Sunday 05 December 2010 13:07:23 Martin Atukunda wrote: > > > > Due to the wonders of MVCC the old row is still available in the > heap. > > >