Re: [GENERAL] Upper/lower case passwords - Mailing list pgsql-general

From Bruce Momjian
Subject Re: [GENERAL] Upper/lower case passwords
Date
Msg-id 199912021744.MAA01049@candle.pha.pa.us
Whole thread Raw
In response to Upper/lower case passwords  (Mark Jewiss <Mark.Jewiss@knowledge.com>)
List pgsql-general
> Hello,
>
> I've come across this in the past day or so, is anyone else aware of the
> issue?
>
> (I've looked over the list archives, the feature list and todo list, with
> no joy).
>
> When creating a user with a password, the password is always converted to
> it's lower case equivalent - no upper case characters are allowed. Enter a
> password with upper case characters in it, and if you try to connect with
> that it will fail - you need to use all lower case.
>
> I'm going to look at the source code to try and resolve this, but before I
> do, has anyone found the problem and solved it yet?

Put double-quotes around the password when you create it.

--
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

pgsql-general by date:

Previous
From:
Date:
Subject: book's pdf link/archive/documentation
Next
From: Bruce Momjian
Date:
Subject: Re: [GENERAL] book's pdf link/archive/documentation