The following issue has been SUBMITTED.
======================================================================
http://www.dbmail.org/mantis/view.php?id=678
======================================================================
Reported By: leonelnunez
Assigned To:
======================================================================
Project: DBMail
Issue ID: 678
Category: Database layer
Reproducibility: always
Severity: minor
Priority: normal
Status: new
target:
======================================================================
Date Submitted: 10-Feb-08 21:53 CET
Last Modified: 10-Feb-08 21:53 CET
======================================================================
Summary: Postgresql 8.3 CAST and dbmail
Description:
PostgreSQL 8.3 changed the automatic cast
there are many errors / warnings in the mail.log
when I add a new user I got this :
Error:[sql] dbpgsql.c,db_query(+287): query failed [SELECT alias FROM
dbmail_aliases WHERE deliver_to = 6 ORDER BY alias DESC] : [ERROR:
operator does not exist: character varying = integer LINE 1: SELECT alias
FROM dbmail_aliases WHERE deliver_to = 6 ORDER ...
^ HINT: No operator matches the given
name and argument type(s). You might need to add explicit type casts. ]
Error:[auth] authsql.c,__auth_query(+293): error executing query
Error:[auth] authsql.c,auth_get_user_aliases(+807): could not retrieve
list
Error:[sql] dbpgsql.c,db_query(+287): query failed [SELECT alias FROM
dbmail_aliases WHERE deliver_to = 6 ORDER BY alias DESC] : [ERROR:
operator does not exist: character varying = integer LINE 1: SELECT alias
FROM dbmail_aliases WHERE deliver_to = 6 ORDER ...
^ HINT: No operator matches the given
name and argument type(s). You might need to add explicit type casts. ]
Error:[auth] authsql.c,__auth_query(+293): error executing query
Error:[auth] authsql.c,auth_get_user_aliases(+807): could not retrieve
list
As the PostgreSQL 8.3 release notes say :
http://www.postgresql.org/docs/8.3/static/release-8-3.html
Non-character data types are no longer automatically cast to TEXT
======================================================================
Issue History
Date Modified Username Field Change
======================================================================
10-Feb-08 21:53 leonelnunez New Issue
======================================================================
_______________________________________________
Dbmail-dev mailing list
[email protected]
http://twister.fastxs.net/mailman/listinfo/dbmail-dev
