From 9a00193e3365f782493e66c97173ef1459a99142 Mon Sep 17 00:00:00 2001
From: Kern Sibbald <kern@sibbald.com>
Date: Sat, 9 Dec 2017 11:53:26 +0100
Subject: [PATCH] Use correct SQL table encoding for Postgresql 10.x

---
 bacula/src/cats/create_postgresql_database.in | 9 +++------
 1 file changed, 3 insertions(+), 6 deletions(-)

diff --git a/bacula/src/cats/create_postgresql_database.in b/bacula/src/cats/create_postgresql_database.in
index ac15d524e8..deff1017c5 100644
--- a/bacula/src/cats/create_postgresql_database.in
+++ b/bacula/src/cats/create_postgresql_database.in
@@ -21,15 +21,12 @@ PSQLVERSION=`psql -d template1 -c 'select version()' $* | awk '/PostgreSQL/ {pri
 # This must be updated for future versions of PostgreSQL
 #
 case ${PSQLVERSION} in
-   9.*)
+   8.[456789] | 9.* | 10.*)
 	ENCODING="ENCODING 'SQL_ASCII' LC_COLLATE 'C' LC_CTYPE 'C'"
    ;;
-   8.[456789])
-	ENCODING="ENCODING 'SQL_ASCII' LC_COLLATE 'C' LC_CTYPE 'C'"
-    ;;
-    *)
+   *)
 	ENCODING="ENCODING 'SQL_ASCII'"
-    ;;
+   ;;
 esac
 
 
-- 
2.39.2