#!/bin/sh

set -eux

# newest supported TDS version on xenial is 7.2

for v in $(pg_buildext supported-versions); do
    pg_virtualenv -v $v psql -Xv ON_ERROR_STOP=1 <<-EOF
	CREATE EXTENSION tds_fdw;
	CREATE SERVER mssql_svr
	FOREIGN DATA WRAPPER tds_fdw
	OPTIONS (servername 'localhost', port '1433', database 'test', tds_version '7.2', msg_handler 'blackhole');
	EOF
done
