SQL question

[Antoine Nguyen]

Le 28/07/2011 18:02, Giampaolo Tomassoni a écrit :
>> By the way, I didn't notice the 'quarantine' table was using an
>> explicit
>> composite primary key (between 'mail_id' and 'chunk_ind'). I really
>> don't know how to make it work with django's orm... It smells like I'm
>> going to rollback this work and finally wait for django to support
>> composite keys.
>>
>> Anybody here who has already try to achieve such a thing? :-)
> Change that primary key to an unique index, then create a new auto-increment
> column and set it as the primary key.
>
> There is no (evident?) reason this shouldn't work with both django and
> amavis...
Yes it is one solution.

I've finally found another solution that looks like the one you 
describe. It seems using the "unique_together" Meta option available for 
models does the trick. Combining this with a fake primary key for models 
that need one should fixed all the issues I encounter.
>
> Besides, django is not the only ORM disliking composite primaries...
>
> Have a look at the following, from the Hibernate user forum:
>
> 	https://forum.hibernate.org/viewtopic.php?f=1&t=964043
>
> Regards,
>
> Giampaolo
I didn't know it was a common issue between ORMs.

Antoine