login errors

[R Summers <..hidden..>]

I experienced the same problem on my 64 bit Ubuntu 7.10 platform.  In this case there is some difference between PostgreSQL 8.3 and previous versions; it 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