Dave Page wrote:
> Guillaume Lelarge wrote:
>> I did it for a group, works great (8.1 and 8.2). Now, I don't really
>> know if this is really a feature or something overlooked. Either pgAdmin
>> is wrong either psql is.
>
> No, in 8.1+ it works for roles whether they are what we would call login
> roles or group roles. In 8.0 and below we had separate users and groups,
> but I'm not sure you could assign ownership to a group back then.
>
You're right. I checked this on a 7.4 (I don't have a 8.0 release
available) and, with this release, a group can't be the owner of a table.
Do you think I should raise the issue (group owner on 8.1+) on
pgsql-hackers ?
>> I'll take a look at the query tool to see how to do this ("present a
>> list of databases on the server"). Another call to wxSingleChoiceDialod
>> seems a bad way to me... I'll need to add a new dialog, don't you think ?
>
> Yes, I don't think it should be two dialogues.
>
I'm working on it now.
--
Guillaume.
http://www.postgresqlfr.org
http://dalibo.com