Re: [BUGS] BUG #1134: ALTER USER ... RENAME breaks md5 passwords

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr>, PostgreSQL-patches <pgsql-patches(at)postgresql(dot)org>
Subject: Re: [BUGS] BUG #1134: ALTER USER ... RENAME breaks md5 passwords
Date: 2004-04-30 17:02:42
Message-ID: 200404301702.i3UH2gk26428@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-patches

Tom Lane wrote:
> Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
> > The attached patch clears the password field on rename:
>
> I think you should clear the password field *only* if it's
> MD5-encrypted.

I thought about that but it seems strange to conditionally do the
clearing, but if you think we should, I can do it.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2004-05-01 01:23:41 Re: BUG #1145: silent REVOKE failures
Previous Message Tom Lane 2004-04-30 16:52:05 Re: [BUGS] BUG #1134: ALTER USER ... RENAME breaks md5 passwords

Browse pgsql-patches by date

  From Date Subject
Next Message Neil Conway 2004-04-30 19:12:32 Re: width_bucket() per SQL2003 (WIP)
Previous Message Andrew Dunstan 2004-04-30 16:55:08 Re: win32 build and test issues