Re: One Role, Two Passwords

* Robert Haas (robertmhaas@gmail.com) wrote:
> It strikes me that it would be useful to have a GUC that sets the
> owner of any new objects you create (much as you can control their
> default schemas using search_path).

There was a great deal of discussion along these lines over the summer
of '09 (iirc) with regard to default owners and with the default
privileges patch.  I encourage you to try and make it happen though.

> It's always struck me that using multiple
> database logins would create all sorts of inconsistencies with
> different objects ending up owned by different users, but I guess
> until recently I was under the impression I was the only one who had
> an issue with that.  It seems not.

Uh, no, you're definitely not alone.  It's a huge pain in the ass,
imv.
Thanks,
    Stephen