diff options
| -rw-r--r-- | contrib/dblink/expected/dblink.out | 8 | ||||
| -rw-r--r-- | contrib/dblink/sql/dblink.sql | 6 |
2 files changed, 0 insertions, 14 deletions
diff --git a/contrib/dblink/expected/dblink.out b/contrib/dblink/expected/dblink.out index 974d001be93..78b4a99606a 100644 --- a/contrib/dblink/expected/dblink.out +++ b/contrib/dblink/expected/dblink.out @@ -784,14 +784,6 @@ SELECT dblink_disconnect('dtest1'); -- test foreign data wrapper functionality CREATE USER dblink_regression_test; CREATE SERVER fdtest FOREIGN DATA WRAPPER dblink_fdw - OPTIONS (invalid 'val'); -- fail, invalid option -ERROR: invalid option "invalid" -HINT: Valid options in this context are: service, connect_timeout, dbname, host, hostaddr, port, application_name, fallback_application_name, keepalives, keepalives_idle, keepalives_interval, keepalives_count, sslmode, sslcompression, sslcert, sslkey, sslrootcert, sslcrl, requirepeer -CREATE SERVER fdtest FOREIGN DATA WRAPPER dblink_fdw - OPTIONS (password 'val'); -- fail, can't specify password here -ERROR: invalid option "password" -HINT: Valid options in this context are: service, connect_timeout, dbname, host, hostaddr, port, application_name, fallback_application_name, keepalives, keepalives_idle, keepalives_interval, keepalives_count, sslmode, sslcompression, sslcert, sslkey, sslrootcert, sslcrl, requirepeer -CREATE SERVER fdtest FOREIGN DATA WRAPPER dblink_fdw OPTIONS (dbname 'contrib_regression'); CREATE USER MAPPING FOR public SERVER fdtest OPTIONS (server 'localhost'); -- fail, can't specify server here diff --git a/contrib/dblink/sql/dblink.sql b/contrib/dblink/sql/dblink.sql index 0372af61827..4f72ccf1d8e 100644 --- a/contrib/dblink/sql/dblink.sql +++ b/contrib/dblink/sql/dblink.sql @@ -360,14 +360,8 @@ SELECT dblink_disconnect('dtest1'); -- test foreign data wrapper functionality CREATE USER dblink_regression_test; - -CREATE SERVER fdtest FOREIGN DATA WRAPPER dblink_fdw - OPTIONS (invalid 'val'); -- fail, invalid option -CREATE SERVER fdtest FOREIGN DATA WRAPPER dblink_fdw - OPTIONS (password 'val'); -- fail, can't specify password here CREATE SERVER fdtest FOREIGN DATA WRAPPER dblink_fdw OPTIONS (dbname 'contrib_regression'); - CREATE USER MAPPING FOR public SERVER fdtest OPTIONS (server 'localhost'); -- fail, can't specify server here CREATE USER MAPPING FOR public SERVER fdtest; |