Re: Withdraw PL/Proxy from commitfest

Hannu Krosing wrote:

> In my brief reading of SQL-MED spec I could only find info on defining
> FOREIGN SERVER and FOREIGN-DATA WRAPPER and nowhere in these could one
> define connection parameters like username and password.

It is cleverly hidden. The CREATE SERVER and CREATE USER MAPPING take
generic options (list of key/value pairs). These can be used for
defining the actual connection to the remote server.

From http://www.wiscorp.com/sql_2003_standard.zip "4.4 User mappings":

"A user mapping is an SQL-environment element, pairing an ...
... The mapping is specified by generic options defined by the
foreign-data wrapper."

and "13.3 <user mapping definition>":

<user mapping definition> ::=
CREATE USER MAPPING FOR <specific or generic authorization identifier>
SERVER <foreign server name> [ <generic options> ]

regards,
Martin