Re: MD5 question? - Mailing list pgsql-general

From Tom Lane
Subject Re: MD5 question?
Date
Msg-id 7809.1039447505@sss.pgh.pa.us
Whole thread Raw
In response to MD5 question?  (Çağıl Şeker <cagils@biznet.com.tr>)
List pgsql-general
=?iso-8859-9?B?x2Hw/Wwg3mVrZXI=?= <cagils@biznet.com.tr> writes:
> Then I change a user's passwd by UPDATE pg_shadow set passwd blablabla
> SQL command to for example 'qwerty' without md5 hashing.

You shouldn't do that.  There is an ALTER USER command for changing
users' passwords.  Any time you directly hack on the system catalogs,
it's up to you to know what you are doing and what the consequences
will be.

            regards, tom lane

pgsql-general by date:

Previous
From: "Fernando Papa"
Date:
Subject: Re: Table functions say "no destination for result data."
Next
From: Tom Lane
Date:
Subject: Re: pg 7.3 memory error