Metacat

-- these are ones that should be marked as archived=true but are not

select sm. guid --count(sm.guid)

from systemmetadata sm, identifier id

where sm.guid = id.guid

and not exists (select * from xml_documents doc where doc.docid = id.docid and doc.rev = id.rev)

and sm.archived != true

and sm.obsoleted_by is null;

-- update them

BEGIN;

update systemmetadata sm

set sm.archived = true

from identifier id

where sm.guid = id.guid

and not exists (select * from xml_documents doc where doc.docid = id.docid and doc.rev = id.rev)

and sm.archived != true

and sm.obsoleted_by is null;

COMMIT;

--ROLLBACK;