Thanks a lot Greg!
On 11/01/2011, at 12:41, Greg Smith <g...@2ndquadrant.com> wrote: > 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 g...@2ndquadrant.com Baltimore, MD > PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.us > "PostgreSQL 9.0 High Performance": http://www.2ndQuadrant.com/books
