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
> 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
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.
> > >