comparison schema/update-db.sh @ 3979:5396581cf203 v4-preview20190717

Put updates in a single transaction.
author Sascha Wilde <wilde@intevation.de>
date Wed, 17 Jul 2019 12:13:08 +0200
parents 7b7c324b318f
children 2fa052a44300
comparison
equal deleted inserted replaced
3978:7b7c324b318f 3979:5396581cf203
102 new_ver=$( basename $d ) 102 new_ver=$( basename $d )
103 if [ -d "$d" -a "$new_ver" -gt $current_ver ] ; then 103 if [ -d "$d" -a "$new_ver" -gt $current_ver ] ; then
104 echo "Running updates for $new_ver ..." 104 echo "Running updates for $new_ver ..."
105 105
106 sql=$( cat `echo "$d/"* | sort -n` ) 106 sql=$( cat `echo "$d/"* | sort -n` )
107 psql -q -p "$port" -d "$db" -c "$sql" 107 psql -1 -q -p "$port" -d "$db" -c "$sql"
108 fi 108 fi
109 done 109 done