Re: User mapping

On Wed, Mar 23, 2011 at 10:10 PM, Guillaume Lelarge
<guillaume(at)lelarge(dot)info> wrote:
> Hi,
>
> I'm looking at adding user mapping support. My first idea was to add
> them as children of foreign servers, but it doesn't seem this was a
> really good idea. They have no OIDs, no owners, no comments... geez, no
> nothing actually. They don't seem like objects, meaning they can't be in
> their own node (with no OID, refresh wouldn't work for example).

They do have OIDs - and even without, refresh can be made to work
easily. We'd just need to refresh based on the unique key (umuser +
umserver).

> My second idea was to add a "User mapping" tab on the foreign server
> dialog, so that we could directly add user mapping to servers. It still
> seems a good idea to me.

After thinking about it last night, I think the treeview is the
correct method. Add a user mappings node under the server. You're
correct in that is would be pretty simple, but that doesn't matter. I
would expect to see two tabs on the properties dialogue, one with OID
and username (and comment, if that is added in PG), and one with a
listview of key/value pairs for the options, in a similar layout to
the role/database variables tab.

--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company