The following issue has been RESOLVED.
======================================================================
http://www.dbmail.org/mantis/view.php?id=678
======================================================================
Reported By: leonelnunez
Assigned To: paul
======================================================================
Project: DBMail
Issue ID: 678
Category: Database layer
Reproducibility: always
Severity: minor
Priority: normal
Status: resolved
target:
Resolution: fixed
Fixed in Version:
======================================================================
Date Submitted: 10-Feb-08 21:53 CET
Last Modified: 15-Mar-08 10:23 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
======================================================================
Relationships ID Summary
----------------------------------------------------------------------
duplicate of 0000676 cannot create aliases with PostgreSQL
======================================================================
----------------------------------------------------------------------
paul - 10-Feb-08 22:12
----------------------------------------------------------------------
Leonel,
it's a known issue. See http://www.dbmail.org/mantis/view.php?id=676
The aliases table needs fixing.
----------------------------------------------------------------------
paul - 15-Mar-08 10:23
----------------------------------------------------------------------
see http://www.dbmail.org/mantis/view.php?id=676
Issue History
Date Modified Username Field Change
======================================================================
10-Feb-08 21:53 leonelnunez New Issue
10-Feb-08 22:11 paul Relationship added duplicate of 0000676
10-Feb-08 22:12 paul Note Added: 0002483
15-Mar-08 10:23 paul Status new => resolved
15-Mar-08 10:23 paul Resolution open => fixed
15-Mar-08 10:23 paul Assigned To => paul
15-Mar-08 10:23 paul Note Added: 0002525
======================================================================
_______________________________________________
Dbmail-dev mailing list
[email protected]
http://twister.fastxs.net/mailman/listinfo/dbmail-dev
