summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authoreinhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46>2008-02-24 20:30:59 +0000
committereinhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46>2008-02-24 20:30:59 +0000
commit13938186203ef7181d437ee11e699199d5d9d9aa (patch)
tree2766b3e1cf437dadb4d13fa7516c157efe2232be
parent32ee2de4dbd5509e7093fa11a905dd764e796c1b (diff)
Adding explicit cast to md5() so it will work on Pg 8.3
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2085 4979c152-3d1c-0410-bac9-87ea11338e46
-rw-r--r--sql/modules/Session.sql2
1 files changed, 1 insertions, 1 deletions
diff --git a/sql/modules/Session.sql b/sql/modules/Session.sql
index 58de0f2e..8b8b65c6 100644
--- a/sql/modules/Session.sql
+++ b/sql/modules/Session.sql
@@ -28,7 +28,7 @@ BEGIN
END IF;
INSERT INTO session(users_id, token, last_used, transaction_id)
- SELECT id, md5(random()), now(), 0
+ SELECT id, md5(random()::text), now(), 0
FROM users WHERE username = SESSION_USER;
-- TODO-- remove transaction_id field from session table