On Tue, 2006-01-24 at 09:44 -0500, Stephen Frost wrote:
> * Christopher Kings-Lynne (chriskl@familyhealth.com.au) wrote:
> > Hmmmm...actually. It's because I have a user called 'support' and a
> > group called 'support'.
> >
> > Seems like it needs a fix...
>
> Have you got a suggestion on just how to fix it...? Debian's
> pg_upgradecluster bails out with an error when it discovers this
> situation but I don't think it'd be sensible for pg_dump to do that...
>
How about an option to map groups whose names conflict with user names
using a prefix mechanism?
e.g. --map-conflicting-groups=gr_
Then in Christopher's example his support group would become the role
gr_support.
Just a thought.
cheers
andrew
