The following issue has been RESOLVED. ====================================================================== http://www.dbmail.org/mantis/view.php?id=676 ====================================================================== Reported By: Maarten Deprez Assigned To: paul ====================================================================== Project: DBMail Issue ID: 676 Category: Authentication layer Reproducibility: always Severity: minor Priority: normal Status: resolved target: Resolution: fixed Fixed in Version: 2.2.10 ====================================================================== Date Submitted: 06-Feb-08 11:59 CET Last Modified: 15-Mar-08 10:22 CET ====================================================================== Summary: cannot create aliases with PostgreSQL Description: I had to do a few changes in modules/authsql.c to make aliases work with PostgreSQL 8.3RC2 . The error is it cannot compare deliver_to (varchar) to an int user id. So you need to change "deliver_to = %llu" to "deliver_to = '%llu'" in queries. Hope this doesn't break for other databases. ====================================================================== Relationships ID Summary ---------------------------------------------------------------------- has duplicate 0000678 Postgresql 8.3 CAST and dbmail ======================================================================
---------------------------------------------------------------------- paul - 15-Mar-08 10:22 ---------------------------------------------------------------------- I'm committing the required changes to authsql.c The deliver_to field should indeed always be treated as a string type in queries. Issue History Date Modified Username Field Change ====================================================================== 06-Feb-08 11:59 Maarten Deprez New Issue 10-Feb-08 22:11 paul Relationship added has duplicate 0000678 15-Mar-08 10:22 paul Note Added: 0002524 15-Mar-08 10:22 paul Assigned To => paul 15-Mar-08 10:22 paul Status new => resolved 15-Mar-08 10:22 paul Resolution open => fixed 15-Mar-08 10:22 paul Fixed in Version => 2.2.10 ====================================================================== _______________________________________________ Dbmail-dev mailing list [email protected] http://twister.fastxs.net/mailman/listinfo/dbmail-dev
