# HG changeset patch # User Peter Gervai # Date 1646388060 -3600 # Node ID c636ea2e8ee13256f3603254a9388db11c447b45 # Parent b92f5cceab786eda9a99b6d5d3c99e55091f9cd6 cmd.sh: I dislike shell escaping, and it doesn't like me either. (fix escaped ') diff -r b92f5cceab78 -r c636ea2e8ee1 synapse/cmd.sh --- a/synapse/cmd.sh Fri Mar 04 10:54:52 2022 +0100 +++ b/synapse/cmd.sh Fri Mar 04 11:01:00 2022 +0100 @@ -56,13 +56,13 @@ if [ "$MODE" = "unts" ]; then echo "Creating unts() function; needs write access or you can simply copy the following code into psql." echo " " - SQL='CREATE OR REPLACE FUNCTION public.unts(bigint) + SQL="CREATE OR REPLACE FUNCTION public.unts(bigint) RETURNS timestamp with time zone LANGUAGE sql IMMUTABLE STRICT -AS $function$ - SELECT TIMESTAMP WITH TIME ZONE ''epoch'' + $1/1000 * INTERVAL ''1 second'' -$function$' +AS \$function$ + SELECT TIMESTAMP WITH TIME ZONE 'epoch' + \$1/1000 * INTERVAL '1 second' +\$function$" echo "${SQL}" echo " " $CMD "${SQL}"