Nicolas Garfinkiel wrote:
Iâm trying to upgrade our pgsql from 8.1 to 8.4,
but
our systemâs login uses the hashname() function in order to get the
proper password validation. Now pgsqlâs 8.4 hashname function is not
compatible with 8.1âs function. Do you have any ideas how I can
reproduce
8.1 function in 8.4?
https://github.com/petere/pgvihash provides the function you're looking
for.
I agree with Craig's concerns here, but this may let you convert toward
a better long-term format more easily.
--
Greg Smith 2ndQuadrant US greg@xxxxxxxxxxxxxxx Baltimore, MD
PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.us
"PostgreSQL 9.0 High Performance": http://www.2ndQuadrant.com/books