Skip site navigation (1) Skip section navigation (2)

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

From: "Martin Atukunda" <matlads(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #5784: CREATE INDEX USING GIN complains about array containing null values yet none exist
Date: 2010-12-05 06:50:51
Message-ID: 201012050650.oB56opvM090787@wwwmaster.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      5784
Logged by:          Martin Atukunda
Email address:      matlads(at)gmail(dot)com
PostgreSQL version: 8.4
Operating system:   Linux
Description:        CREATE INDEX USING GIN complains about array containing
null values yet none exist
Details: 

CREATE INDEX USING GIN complains about array containing null values yet none
exist.

Take the following SQL as an example.

-- >8 --

BEGIN;
CREATE TABLE t (id serial primary key, apps bigint[]);
INSERT INTO t (apps) VALUES ('{1,2,3,4}');
INSERT INTO t (apps) VALUES ('{1,2,3,4}');

-- insert an array with one element as a null value
INSERT INTO t (apps) VALUES ('{1,2,3,NULL}');

-- remove the null value
UPDATE t SET apps[4] = -1 WHERE apps[4] IS NULL;

-- the create index fails
CREATE INDEX  t_apps_idx ON t USING GIN(apps);

COMMIT;

-- 8< --


note that index creatiion succeeds if I first create the index without
inserting a row containing an array with a null element.

- Martin -

Responses

pgsql-bugs by date

Next:From: Andres FreundDate: 2010-12-05 11:39:23
Subject: Re: BUG #5784: CREATE INDEX USING GIN complains about array containing null values yet none exist
Previous:From: Adrian KlaverDate: 2010-12-05 00:25:27
Subject: BUG #5783: plpythonu bool behavior change

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group