THESAURUS_premigr_1.1.0

#!/bin/bash

if [ -z "$pgservice_core" ]; then
	echo "Undefined or empty pgservice_core!"
	exit 1
fi

PGSERVICE="$pgservice_core" psql --set ON_ERROR_STOP=on -f - <<EOF
BEGIN;
UPDATE ONLY docattr SET type = 'enum' FROM docfam WHERE docfam.name = 'THESAURUS' AND docfam.id = docattr.docid AND docattr.id = 'thes_lang' AND docattr.type = 'enumlist';
COMMIT;
EOF
RET=$?
if [ $RET -ne 0 ]; then
    echo "Error updating thesaurus attributes."
    exit $RET
fi