Re: login errors

[R Summers <..hidden..>]

I experienced the same problem.  There seems to be some difference between PostgreSQL 8.3 and previous versions; this requires an explicit cast...

Modify the file DB.pm by changing line 160 from:

my $fetchSequence = $dbh->prepare("SELECT nextval('session_session_id_seq'), md5(random());");

to:

my $fetchSequence = $dbh->prepare("SELECT nextval('session_session_id_seq'), md5(random()::text);");

Notice the change 'md5(random()::text)' which is an explicit cast from double to text by PostgreSQL so that md5() can accept it.  I reported this in the developers list today.

R Summers