Heikki Linnakangas <heikki.linnakangas@enterprisedb.com> writes:
> On 22.07.2011 11:08, Albe Laurenz wrote:
>> Or is a user mapping intended to be the only source of
>> connection information?
> No, you can specify connection details at per-server and
> per-foreign-table level too. The FDW implementation is free to accept or
> reject options where-ever it wants.
Well, if we are going to take that viewpoint, then not having a user
mapping *shouldn't* be an error, for any use-case. What would be an
error would be not having the foreign-user-name-or-equivalent specified
anywhere in the applicable options, but it's up to the FDW to notice and
complain about that.
I am not, however, convinced that that's a legitimate reading of the SQL
spec. Surely user mappings are meant to constrain which users can
connect to a given foreign server.
regards, tom lane