5 INSERT INTO biblio.record_entry (id, last_xact_id, marc)
6 VALUES (999999998, 'pgtap', '<record xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.loc.gov/MARC21/slim http://www.loc.gov/standards/marcxml/schema/MARC21slim.xsd" xmlns="http://www.loc.gov/MARC21/slim">
7 <leader>00531nam a2200157 a 4500</leader>
8 <controlfield tag="005">20080729170300.0</controlfield>
9 <controlfield tag="008"> t19981999enka 0 eng </controlfield>
10 <datafield tag="245" ind1="1" ind2="4">
11 <subfield code="a">test-value</subfield>
15 INSERT INTO biblio.monograph_part(record, label) VALUES (999999998, 'Part 1');
20 'LP#1569884: new monograph parts start out active'
22 FROM biblio.monograph_part
23 WHERE record = 999999998
26 DELETE FROM biblio.monograph_part WHERE record = 999999998;
31 'LP#1569884: deleting monograph part sets deleted flag'
33 FROM biblio.monograph_part
34 WHERE record = 999999998
38 $$INSERT INTO biblio.monograph_part(record, label) VALUES (999999998, 'Part 1')$$,
39 'LP#1569884: can add monograph part with same label as logically deleted one'
45 'LP#1569884: one active part with label Part 1'
47 FROM biblio.monograph_part
48 WHERE record = 999999998