SQL question

Antoine Nguyen tonio at ngyn.org
Thu Jul 28 15:33:15 CEST 2011


Hi list,

for my quarantine managment application, I'm trying to use Django's 
internal ORM to access Amavis database. Almost everything works fine, 
except for the 'msgrcpt' table.

Django complains about the fact this table does not present a direct 
primary key (I guess it is a composite key between the 'mail_id' and 
'rid' fields?). It is a shame but currently, django does not support :
* tables (models) without primary key,
* composite primary keys.

As I'm not going to wait for a potential django's update about this 
feature, I'm trying to look for another solution and here is my question:

Would it be problematic if I add a new field to the 'msgrcpt' table, 
like an auto incremented integer field that will act as a primary key 
only for django ?

Thanks for your help.

-- 
Antoine Nguyen
Modoboa developer
http://modoboa.org



More information about the amavis-users mailing list