Re: [GENERAL] Upper/lower case passwords

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Mark Jewiss <Mark(dot)Jewiss(at)knowledge(dot)com>
Cc: pgsql-general(at)postgreSQL(dot)org
Subject: Re: [GENERAL] Upper/lower case passwords
Date: 1999-12-02 17:44:27
Message-ID: 199912021744.MAA01049@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 1999-12-02 17:46:02 Re: [GENERAL] book's pdf link/archive/documentation
Previous Message kaiq 1999-12-02 17:07:23 Re: [GENERAL] Except operation