More fixes for public.oils_tsearch2
authorDan Wells <dbw2@calvin.edu>
Thu, 20 Feb 2014 16:52:19 +0000 (11:52 -0500)
committerDan Wells <dbw2@calvin.edu>
Thu, 20 Feb 2014 16:52:19 +0000 (11:52 -0500)
commita4ae7bff788af63e00d0c7ab7b10ef4366c59f42
tree699748a5932e368ea0cdd611911c703c7b84bbad
parent30cfc932766fcec8fe1f122c2429b30e9630cb5f
More fixes for public.oils_tsearch2

First, we don't want to fully exclude records which don't have a
metabib.record_attr_vector_list entry, so we do a LEFT JOIN instead
for that table.  Otherwise, some records error out when ingesting
(see placeholder record -1 in the stock data set).

Second, let's add a check for 'active' which appears to have been
always missing.

Signed-off-by: Dan Wells <dbw2@calvin.edu>
Open-ILS/src/sql/Pg/030.schema.metabib.sql
Open-ILS/src/sql/Pg/upgrade/QQQQ.MVF_CRA-upgrade.sql