Re: [GENERAL] migrate hashname function from 8.1.x to 8.4

2011-01-14 Thread Jasen Betts
On 2011-01-11, =?utf-8?Q?Nicol=C3=A1s_Garfinkiel?= wrote: > Violence aside, thanks for your answer. The C module is what I was > planning to do, but was not sure if there is another way. Of course > using crypt would be the right thing to do, but I cannot afford it, as > users from our system c

Re: [GENERAL] migrate hashname function from 8.1.x to 8.4

2011-01-11 Thread Nicolás Garfinkiel
Thanks a lot Greg! On 11/01/2011, at 12:41, Greg Smith 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

Re: [GENERAL] migrate hashname function from 8.1.x to 8.4

2011-01-11 Thread Greg Smith
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

Re: [GENERAL] migrate hashname function from 8.1.x to 8.4

2011-01-11 Thread Nicolás Garfinkiel
Indeed Craig, I would like to smack the guy as well, for this and many many other creepy crawlers in my everyday job! Violence aside, thanks for your answer. The C module is what I was planning to do, but was not sure if there is another way. Of course using crypt would be the right thing to do

Re: [GENERAL] migrate hashname function from 8.1.x to 8.4

2011-01-11 Thread Craig Ringer
On 01/11/2011 03:02 PM, nicolas.garfink...@genesis-manlab.com.ar wrote: well, what i mean is that hashname() function would return a different value depending the pgsql version. Yep. It seems to be an undocumented function with no particular defined behaviour. This isn't especially surprising

Re: [GENERAL] migrate hashname function from 8.1.x to 8.4

2011-01-10 Thread nicolas . garfinkiel
n any kind of refactoring, as plans are underway to develop a new system. what we are looking for is just a quick fix, if there's such thing out there! Any thoughts? Original Message -- >Date: Tue, 11 Jan 2011 10:25:59 +1100 >From: Craig Ringer >To: Nicolas Garfinkiel >CC: pgsql-g

Re: [GENERAL] migrate hashname function from 8.1.x to 8.4

2011-01-10 Thread Craig Ringer
On 01/11/2011 02:09 AM, Nicolas Garfinkiel wrote: Hi all, 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

[GENERAL] migrate hashname function from 8.1.x to 8.4

2011-01-10 Thread Nicolas Garfinkiel
Hi all, 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?