Re: MD5 question?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Çağıl Şeker <cagils(at)biznet(dot)com(dot)tr>
Cc: "PostgreSQL-General-List (E-mail)" <pgsql-general(at)postgresql(dot)org>
Subject: Re: MD5 question?
Date: 2002-12-09 15:25:05
Message-ID: 7809.1039447505@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

=?iso-8859-9?B?x2Hw/Wwg3mVrZXI=?= <cagils(at)biznet(dot)com(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2002-12-09 15:39:24 Re: pg 7.3 memory error
Previous Message Fernando Papa 2002-12-09 15:22:55 Re: Table functions say "no destination for result data."