Since django do not support composite primary keys, I'm forced to use plain 
SQL queries.

I got two databases defined and when I try to use UPDATE or INSERT, it 
simply do nothing:

        cursor = connections['foods'].cursor()
        cursor.execute(sql)

I tried transaction.commit()
cursor.db.set_dirty()

transaction.commit_unless_managed()

Nothing helps. Data not saved in database.

I checked if SQL was valid by executing query through postgres shell. It 
executed successfully.



P.S. I got the following index defined:

    "MeasureWeight_pkey" PRIMARY KEY, btree ("foodCode", measure, amount, 
"weightGm")


-- 
You received this message because you are subscribed to the Google Groups 
"Django users" group.
To view this discussion on the web visit 
https://groups.google.com/d/msg/django-users/-/kb_CT4YKlXUJ.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to 
[email protected].
For more options, visit this group at 
http://groups.google.com/group/django-users?hl=en.

Reply via email to