I think the behaviour on the wire should be more explcitly stated.
cheers
andrew
Bruce Momjian wrote:
------------------------------------------------------------------------
Index: doc/src/sgml/client-auth.sgml
===================================================================
RCS file: /cvsroot/pgsql/doc/src/sgml/client-auth.sgml,v
retrieving revision 1.75
diff -c -c -r1.75 client-auth.sgml
*** doc/src/sgml/client-auth.sgml 21 Apr 2005 22:19:19 -0000 1.75
--- doc/src/sgml/client-auth.sgml 21 Apr 2005 22:23:47 -0000
***************
*** 575,583 ****
The password-based authentication methods are <literal>md5</>,
<literal>crypt</>, and <literal>password</>. These methods operate
similarly except for the way that the password is sent across the
! connection. However, only <literal>md5</> allows encrypted
! passwords to be stored in <structname>pg_shadow</structname>;
! the other two require unencrypted passwords to be stored there.
</para>
<para>
--- 575,582 ----
The password-based authentication methods are <literal>md5</>,
<literal>crypt</>, and <literal>password</>. These methods operate
similarly except for the way that the password is sent across the
! connection. However, <literal>crypt</> does not allow encrypted
! passwords to be stored in <structname>pg_shadow</structname>.
</para>
<para>
------------------------------------------------------------------------
---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
