Re: One Role, Two Passwords

* Robert Haas (robertmhaas(at)gmail(dot)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