summaryrefslogtreecommitdiff
path: root/test/scripts/2620-Postgresql
diff options
context:
space:
mode:
authorJeremy Harris <jgh146exb@wizmail.org>2017-12-27 11:11:17 +0000
committerJeremy Harris <jgh146exb@wizmail.org>2017-12-27 11:13:06 +0000
commit2b665c130a451eb5bfa7315ad6854b83db73d9a3 (patch)
tree0975cd675417019b3e79d7eb3878a7d97d18b4a5 /test/scripts/2620-Postgresql
parentbbfb5dcd8ece2bbf04cc7323b7cc03581d91d7bd (diff)
Testsuite: better portability of postgresq test vs. postgresql versions
Diffstat (limited to 'test/scripts/2620-Postgresql')
-rw-r--r--test/scripts/2620-Postgresql/262018
1 files changed, 10 insertions, 8 deletions
diff --git a/test/scripts/2620-Postgresql/2620 b/test/scripts/2620-Postgresql/2620
index ba3a3bcc8..ae5dca130 100644
--- a/test/scripts/2620-Postgresql/2620
+++ b/test/scripts/2620-Postgresql/2620
@@ -5,20 +5,22 @@ sudo rm -fr DIR/pgsql
perl
system 'initdb -D DIR/pgsql/data';
****
+sudo rm test-stdout
background
/usr/bin/postgres -D DIR/pgsql/data -p PORT_N -k DIR/pgsql
****
+sleep 1
perl
system 'createdb -h localhost -p PORT_N test';
system 'psql -h localhost -p PORT_N -d test \
- -c "CREATE TABLE them ( name text, id text );" \
- -c "INSERT INTO them VALUES ( \'Philip Hazel\', \'ph10\' );" \
- -c "INSERT INTO them VALUES ( \'Aristotle\', \'aaaa\' );" \
- -c "INSERT INTO them VALUES ( \'\', \'nothing\' );" \
- -c "INSERT INTO them VALUES ( \'\"stquot\', \'quote2\' );" \
- -c "INSERT INTO them VALUES ( \'before\' || CHR(13) || CHR(10) || \'after\', \'newline\' );" \
- -c "INSERT INTO them VALUES ( \'x\' || CHR(9) || \'x\', \'tab\' );" \
- -c "INSERT INTO them VALUES ( CHR(39) || \'stquot\', \'quote1\' );" \
+ -c "CREATE TABLE them ( name text, id text ); \
+ INSERT INTO them VALUES ( \'Philip Hazel\', \'ph10\' ); \
+ INSERT INTO them VALUES ( \'Aristotle\', \'aaaa\' ); \
+ INSERT INTO them VALUES ( \'\', \'nothing\' ); \
+ INSERT INTO them VALUES ( \'\"stquot\', \'quote2\' ); \
+ INSERT INTO them VALUES ( \'before\' || CHR(13) || CHR(10) || \'after\', \'newline\' ); \
+ INSERT INTO them VALUES ( \'x\' || CHR(9) || \'x\', \'tab\' ); \
+ INSERT INTO them VALUES ( CHR(39) || \'stquot\', \'quote1\' );" \
';
****
#