Project

General

Profile

« Previous | Next » 

Revision 7353

correct the update statement for setting archived flag on SM where document revision does not exist in the xml_documents table

View differences:

src/system_metadata_revisions.sql
36 36
-- update them
37 37
BEGIN;
38 38
update systemmetadata sm
39
set sm.archived = true
39
set archived = true
40 40
from identifier id
41 41
where sm.guid = id.guid
42 42
and not exists (select * from xml_documents doc where doc.docid = id.docid and doc.rev = id.rev)

Also available in: Unified diff