In-DB unapi / monograph parts conflict

[Bill Erickson]

EG version: 2.1/trunk
OpenSRF: 2.0
PG : 9.0.3
Linux: Squeeze
---------

Records with monograph parts result in PG error when calling unapi.bre(). This currently only affects the T-pac.

evergreen=# select * from biblio.monograph_part;
 id | record | label | label_sortkey
----+--------+-------+---------------
  1 | 393 | 4 | 0000000004
  2 | 393 | 1 | 0000000001

---------------
evergreen=# SELECT * FROM unapi.bre( '393', 'marcxml', 'record', '{holdings_xml,mra}', 'CONS', '0', '5' ) AS "unapi.bre" ;
ERROR: more than one row returned by a subquery used as an expression
CONTEXT: SQL function "holdings_xml" statement 1
PL/pgSQL function "bre" line 43 at assignment

[Mike Rylander (mrylander)]

This, and many other incorrect (as of pg 9.0, I believe) uses of XMLAGG are fixed in the master-ready branch at http://git.evergreen-ils.org/?p=working/Evergreen.git;a=shortlog;h=refs/heads/user/miker/unapi_xmlagg_cleanup

[Bill Erickson (berick)]

Changes pushed to master/rel_2_1

[Bill Erickson (berick)]

Verified fix repaires template toolkit opac display, which was original source of the problem.