ON CONFLICT DO UPDATE

Поиск
Список
Период
Сортировка
От tango ward
Тема ON CONFLICT DO UPDATE
Дата
Msg-id CAA6wQL+Os7BMmowFQqBYLZJdmw6faGn+xbe=OpRa7u7mqC=joQ@mail.gmail.com
обсуждение исходный текст
Ответы Re: ON CONFLICT DO UPDATE
Список 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 по дате отправления: