ON CONFLICT DO UPDATE - Mailing list pgsql-general

From tango ward
Subject ON CONFLICT DO UPDATE
Date
Msg-id CAA6wQL+Os7BMmowFQqBYLZJdmw6faGn+xbe=OpRa7u7mqC=joQ@mail.gmail.com
Whole thread Raw
Responses Re: ON CONFLICT DO UPDATE
List pgsql-general

Hi,

Sorry for asking question again.

I would like to know if there's a workaround for this. I need to insert Student Balance data into a table. The source data have duplicate values for student_id, school_id and campus_name. My StudentBalance model in Djano have Class Meta of:

class Meta:
        unique_together = (
            "school",
            "student_id",
            "campus_name"
        )

Searched online and found this magical tool called ON CONFLICT DO UPDATE. I played around with it, made it work but there's a problem. The balance data is not being updated which is because it's not in class Meta with unique_together. I would like to know if there's a way to update the data in Student Balance column without adding it to the class Meta?


Thanks,
J

pgsql-general by date:

Previous
From: Tim Cross
Date:
Subject: Re: issues when installing postgres
Next
From: Chandru Aroor
Date:
Subject: Re: New install of 9.5.12 missing default PostgreSQL DB