diff options
author | Jeremy Harris <jgh146exb@wizmail.org> | 2017-12-27 11:11:17 +0000 |
---|---|---|
committer | Jeremy Harris <jgh146exb@wizmail.org> | 2017-12-27 11:13:06 +0000 |
commit | 2b665c130a451eb5bfa7315ad6854b83db73d9a3 (patch) | |
tree | 0975cd675417019b3e79d7eb3878a7d97d18b4a5 /test/scripts/2620-Postgresql | |
parent | bbfb5dcd8ece2bbf04cc7323b7cc03581d91d7bd (diff) |
Testsuite: better portability of postgresq test vs. postgresql versions
Diffstat (limited to 'test/scripts/2620-Postgresql')
-rw-r--r-- | test/scripts/2620-Postgresql/2620 | 18 |
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\' );" \ '; **** # |