[GH-ISSUE #296] Postgres issue with release resquests notification #282

New issue

Closed

opened 2026-02-27 11:10:58 +03:00 by kerem · 0 comments

kerem commented

2026-02-27 11:10:58 +03:00

Owner

Originally created by @tonioo on GitHub (Dec 4, 2013).
Original GitHub issue: https://github.com/modoboa/modoboa/issues/296

Originally assigned to: @tonioo on GitHub.

Originally created by Antoine Nguyen on 2012-08-20T20:33:20Z

The current models don't work with postgresql. Amavis uses bytea fields to store emails (instead of varbinary with mysql) and modo is using charfield fields, which doesn't work.

(see https://code.djangoproject.com/ticket/2417)

TemplateSyntaxError at /service/admin/domains/

Caught DatabaseError while rendering: operator does not exist: bytea ~ unknown
LINE 1: ... WHERE ("msgrcpt"."rs" = 'p'  AND "maddr"."email" ~ '(jojo-w...
                                                             ^
HINT:  No operator matches the given name and argument type(s). You might need to add explicit type casts.

Request Method:     GET
Django Version:     1.3.1
Exception Type:     TemplateSyntaxError
Exception Value:    

Caught DatabaseError while rendering: operator does not exist: bytea ~ unknown
LINE 1: ... WHERE ("msgrcpt"."rs" = 'p'  AND "maddr"."email" ~ '(jojo-w...
                                                             ^
HINT:  No operator matches the given name and argument type(s). You might need to add explicit type casts.

Exception Location:     /srv/python-envs/service/lib/python2.7/site-packages/django/db/backends/postgresql_psycopg2/base.py in execute, line 44
Python Executable:  /usr/bin/python
Python Version:     2.7.3
Python Path:    

['/srv/python-envs/service/lib/python2.7/site-packages/distribute-0.6.24-py2.7.egg',
 '/srv/python-envs/service/lib/python2.7/site-packages/pip-1.1-py2.7.egg',
 '/usr/lib/python2.7',
 '/usr/lib/python2.7/plat-linux2',
 '/usr/lib/python2.7/lib-tk',
 '/usr/lib/python2.7/lib-old',
 '/usr/lib/python2.7/lib-dynload',
 '/usr/local/lib/python2.7/dist-packages',
 '/usr/lib/python2.7/dist-packages',
 '/srv/python-envs/service/lib/python2.7/site-packages',
 '/srv/www']

Server time:    Mon, 20 Aug 2012 22:32:33 +0200

Originally created by @tonioo on GitHub (Dec 4, 2013). Original GitHub issue: https://github.com/modoboa/modoboa/issues/296 Originally assigned to: @tonioo on GitHub. **Originally created by Antoine Nguyen on 2012-08-20T20:33:20Z** The current models don't work with postgresql. Amavis uses _bytea_ fields to store emails (instead of varbinary with mysql) and modo is using _charfield_ fields, which doesn't work. (see https://code.djangoproject.com/ticket/2417) <pre> TemplateSyntaxError at /service/admin/domains/ Caught DatabaseError while rendering: operator does not exist: bytea ~ unknown LINE 1: ... WHERE ("msgrcpt"."rs" = 'p' AND "maddr"."email" ~ '(jojo-w... ^ HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts. Request Method: GET Django Version: 1.3.1 Exception Type: TemplateSyntaxError Exception Value: Caught DatabaseError while rendering: operator does not exist: bytea ~ unknown LINE 1: ... WHERE ("msgrcpt"."rs" = 'p' AND "maddr"."email" ~ '(jojo-w... ^ HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts. Exception Location: /srv/python-envs/service/lib/python2.7/site-packages/django/db/backends/postgresql_psycopg2/base.py in execute, line 44 Python Executable: /usr/bin/python Python Version: 2.7.3 Python Path: ['/srv/python-envs/service/lib/python2.7/site-packages/distribute-0.6.24-py2.7.egg', '/srv/python-envs/service/lib/python2.7/site-packages/pip-1.1-py2.7.egg', '/usr/lib/python2.7', '/usr/lib/python2.7/plat-linux2', '/usr/lib/python2.7/lib-tk', '/usr/lib/python2.7/lib-old', '/usr/lib/python2.7/lib-dynload', '/usr/local/lib/python2.7/dist-packages', '/usr/lib/python2.7/dist-packages', '/srv/python-envs/service/lib/python2.7/site-packages', '/srv/www'] Server time: Mon, 20 Aug 2012 22:32:33 +0200 </pre>