| Anonymous | Login | Signup for a new account | 12-Jan-18 00:20 CET |
| Main | My View | View Issues | Change Log | Roadmap | Docs |
| Viewing Issue Advanced Details [ Jump to Notes ] | [ Issue History ] [ Print ] | ||||||
| ID | Category | Severity | Reproducibility | Date Submitted | Last Update | ||
| 0000678 | [DBMail] Database layer | minor | always | 10-Feb-08 21:53 | 15-Mar-08 10:23 | ||
| Reporter | leonelnunez | View Status | public | ||||
| Assigned To | paul | ||||||
| Priority | normal | Resolution | fixed | Platform | i386 | ||
| Status | resolved | OS | Linux | ||||
| Projection | none | OS Version | 2.6.22 | ||||
| ETA | none | Fixed in Version | Product Version | 2.2.9 | |||
| Target Version | Product Build | ||||||
| Summary | 0000678: 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 |
||||||
| Steps To Reproduce |
Install Dbmail 2.2.7 - 2.2.9 with PostgreSQL 8.3 and add a new user |
||||||
| Additional Information | |||||||
| Tags | No tags attached. | ||||||
| target | |||||||
| Attached Files | |||||||
|
|
|||||||
 Relationships |
||||||
|
||||||
|
Notes |
|
|
(0002483) paul (administrator) 10-Feb-08 22:12 |
Leonel, it's a known issue. See 0000676 The aliases table needs fixing. |
|
(0002525) paul (administrator) 15-Mar-08 10:23 |
see 0000676 |
|
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 | |
