CREATE SERVER testserver FOREIGN DATA WRAPPER rdf_fdw OPTIONS ( endpoint 'https://dbpedia.org/sparql' ); CREATE USER u1; /* empty user name */ CREATE USER MAPPING FOR u1 SERVER testserver OPTIONS (user '', password 'foo'); ERROR: empty value in option 'user' /* empty password */ CREATE USER MAPPING FOR u1 SERVER testserver OPTIONS (user 'foo', password ''); ERROR: empty value in option 'password' /* invalid option */ CREATE USER MAPPING FOR u1 SERVER testserver OPTIONS (user 'jim', foo 'bar'); ERROR: invalid rdf_fdw option 'foo' /* empty token */ CREATE USER MAPPING FOR u1 SERVER testserver OPTIONS (token ''); ERROR: empty value in option 'token' /* token combined with user (mutually exclusive) */ CREATE USER MAPPING FOR u1 SERVER testserver OPTIONS (token 'secret', user 'admin'); ERROR: options 'token' and 'user' cannot be combined HINT: Use 'token' for Bearer authentication (RFC 6750) or 'user'/'password' for HTTP Basic Authentication, but not both. /* token combined with user and password (mutually exclusive) */ CREATE USER MAPPING FOR u1 SERVER testserver OPTIONS (token 'secret', user 'admin', password 'pass'); ERROR: options 'token' and 'user' cannot be combined HINT: Use 'token' for Bearer authentication (RFC 6750) or 'user'/'password' for HTTP Basic Authentication, but not both. /* valid token-only mapping */ CREATE USER MAPPING FOR u1 SERVER testserver OPTIONS (token 'secret'); /* clean up */ DROP SERVER testserver CASCADE; NOTICE: drop cascades to user mapping for u1 on server testserver DROP USER u1;