2011-05-24 09:02:39 protostar open-ils.cstore: [ERR :6719:oils_sql.c:6022:13062420571020917] open-ils.cstore ERROR updating biblio::record_entry object with id = 75302: 0 ERROR: array must not contain null values CONTEXT: SQL statement "INSERT INTO reporter.materialized_simple_record SELECT DISTINCT ON (id) * FROM reporter.old_super_simple_record WHERE id = r_id" PL/pgSQL function "simple_rec_update" line 6 at SQL statement SQL statement "SELECT reporter.simple_rec_update(NEW.id)" PL/pgSQL function "simple_rec_trigger" line 5 at PERFORM
Yet...
SELECT DISTINCT ON (id) * FROM reporter.old_super_simple_record WHERE id = 75302;
id | fingerprint | quality | tcn_source | tcn_value | title | author | publisher | pubdate | isbn | issn
-------+--------------------------+---------+------------+-----------+-------------------------+--------------------+-----------+---------+--------+--------
75302 | lecerveauetlapensewilson | 63 | Sirsi_Auto | a75302 | le cerveau et la pensee | wilson, john rowan | time | 1966 | {NULL} | {NULL}
(1 row)
Huh. And what's in reporter.materialized_simple_record?
SELECT * FROM reporter.materialized_simple_record WHERE id = 75302;
id | fingerprint | quality | tcn_source | tcn_value | title | author | publisher | pubdate | isbn | issn
-------+--------------------------+---------+------------+-----------+-------------------------+--------------------+-----------+---------+------+------
75302 | lecerveauetlapensewilson | 63 | Sirsi_Auto | a75302 | le cerveau et la pensee | wilson, john rowan | time | 1966 | {} | {}
(1 row)
Is this because isbn and issn have {NULL} for their text[] types? PostgreSQL 9.0...