Heikki Linnakangas <heikki.linnakan...@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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers