Re: [HACKERS] Case insensitive usernames

2005-05-10 Thread Magnus Hagander
> > Which brings me back to thinking a GUC is the way to deal > with that - > > you'll definitly know what kind of KDC you have when you set up > > Kerberos. But perhaps this GUC should be for "permit > case-insensitive > > kerberos principals" and not "case-insensitive usernames". And it > >

Re: [HACKERS] Case insensitive usernames

2005-05-10 Thread Tom Lane
"Magnus Hagander" <[EMAIL PROTECTED]> writes: > Which brings me back to thinking a GUC is the way to deal with that - > you'll definitly know what kind of KDC you have when you set up > Kerberos. But perhaps this GUC should be for "permit case-insensitive > kerberos principals" and not "case-insens

Re: [HACKERS] Case insensitive usernames

2005-05-10 Thread Magnus Hagander
> > Another way to help in this particular case would be to > have libpq on > > win32 only force-lowercase the username IF it was retreived > from the > > system (but not when manually specified). > > Well, I personally don't care how bizarrely the Win32 port > behaves ;-) so I won't complain

Re: [HACKERS] Case insensitive usernames

2005-05-09 Thread Tom Lane
"Magnus Hagander" <[EMAIL PROTECTED]> writes: > Another way to help in this particular case would be to have libpq on > win32 only force-lowercase the username IF it was retreived from the > system (but not when manually specified). Well, I personally don't care how bizarrely the Win32 port behave

Re: [HACKERS] Case insensitive usernames

2005-05-09 Thread Magnus Hagander
>> I would like to see a GUC variable to enable case >insensitive usernames. >> Would a patch for such a thing be accepted? > >No, not any more than it would be for any other SQL identifiers. See >(many, many) past threads. Yes, I've seen the many past threads on that ;-) I figured it might be a

Re: [HACKERS] Case insensitive usernames

2005-05-09 Thread Tom Lane
"Magnus Hagander" <[EMAIL PROTECTED]> writes: > I would like to see a GUC variable to enable case insensitive usernames. > Would a patch for such a thing be accepted? No, not any more than it would be for any other SQL identifiers. See (many, many) past threads. regards,

[HACKERS] Case insensitive usernames

2005-05-09 Thread Magnus Hagander
Today, usernames are case sensitive. This can cause some problems in for example a kerberos environment (such as a Windows domain, in my case), because the system usernames are case insensitive. So if I log in to my workstation as "Maghag" I cannot connect to postgresql, because my postgresql usern