From f162508ad18b1fca9a5201f4956d52022bd941a8 Mon Sep 17 00:00:00 2001 From: Klaus Weidenbach Date: Fri, 5 May 2017 23:13:54 +0200 Subject: :construction_worker::white_check_mark::bug: Import table structure in TravisCI. Fix a syntax error in schema_postres.sql which was discovered while working on this. --- tests/travis/prepare_pgsql.sh | 13 ++++++++++--- 1 file changed, 10 insertions(+), 3 deletions(-) (limited to 'tests/travis/prepare_pgsql.sh') diff --git a/tests/travis/prepare_pgsql.sh b/tests/travis/prepare_pgsql.sh index dcd83f3be..63c7388cb 100755 --- a/tests/travis/prepare_pgsql.sh +++ b/tests/travis/prepare_pgsql.sh @@ -30,8 +30,15 @@ echo "Preparing for PostgreSQL ..." # Print out some PostgreSQL information psql --version # Why does this hang further execution of the job? -psql -c "SELECT VERSION();" -U postgres +psql -U postgres -c "SELECT VERSION();" # Create Hubzilla database -psql -c "DROP DATABASE IF EXISTS hubzilla;" -U postgres -psql -c "CREATE DATABASE hubzilla;" -U postgres +psql -U postgres -c "DROP DATABASE IF EXISTS hubzilla;" +psql -U postgres -c "CREATE DATABASE hubzilla;" + +# Import table structure +psql -U postgres -v ON_ERROR_STOP=1 hubzilla < ./install/schema_postgres.sql + +# Show databases and tables +psql -U postgres -l +psql -U postgres -d hubzilla -c "\dt;" -- cgit v1.2.3