diff options
| author | Andres Freund <andres@anarazel.de> | 2014-08-26 12:21:06 +0200 |
|---|---|---|
| committer | Andres Freund <andres@anarazel.de> | 2014-08-26 12:28:08 +0200 |
| commit | 57ca1d4f0175f60e9cfb0f997c864173d9c72607 (patch) | |
| tree | 60ec14fef0d4ffa3c8be801adafa5c378014895b /contrib/dblink/expected | |
| parent | ddc2504dbcf2af97b58a91b071768c17774d58d1 (diff) | |
| download | postgresql-57ca1d4f0175f60e9cfb0f997c864173d9c72607.tar.gz | |
Specify the port in dblink and postgres_fdw tests.
That allows to run those tests against a postmaster listening on a
nonstandard port without requiring to export PGPORT in postmaster's
environment.
This still doesn't support connecting to a nondefault host without
configuring it in postmaster's environment. That's harder and less
frequently used though. So this is a useful step.
Diffstat (limited to 'contrib/dblink/expected')
| -rw-r--r-- | contrib/dblink/expected/dblink.out | 6 |
1 files changed, 4 insertions, 2 deletions
diff --git a/contrib/dblink/expected/dblink.out b/contrib/dblink/expected/dblink.out index 60cca8254d..a49b5629a1 100644 --- a/contrib/dblink/expected/dblink.out +++ b/contrib/dblink/expected/dblink.out @@ -89,7 +89,7 @@ SELECT dblink_build_sql_delete('"MySchema"."Foo"','1 2',2,'{"0", "a"}'); (1 row) CREATE FUNCTION connection_parameters() RETURNS text LANGUAGE SQL AS $f$ - SELECT $$dbname='$$||current_database()||$$'$$; + SELECT $$dbname='$$||current_database()||$$' port=$$||current_setting('port'); $f$; -- regular old dblink SELECT * @@ -816,7 +816,9 @@ CREATE ROLE dblink_regression_test; DO $d$ BEGIN EXECUTE $$CREATE SERVER fdtest FOREIGN DATA WRAPPER dblink_fdw - OPTIONS (dbname '$$||current_database()||$$')$$; + OPTIONS (dbname '$$||current_database()||$$', + port '$$||current_setting('port')||$$' + )$$; END; $d$; CREATE USER MAPPING FOR public SERVER fdtest |