Re: ON CONFLICT DO UPDATE - Mailing list pgsql-general

From Adrian Klaver
Subject Re: ON CONFLICT DO UPDATE
Date
Msg-id c1493d83-36a1-1f1b-a0c2-bdde5a1fb9d1@aklaver.com
Whole thread Raw
In response to ON CONFLICT DO UPDATE  (tango ward <tangoward15@gmail.com>)
List pgsql-general
On 05/09/2018 09:50 PM, tango ward wrote:

Ccing list.
> 
> Hi,
> 
> this is the my ON CONFLICT CODE
> 
> ON CONFLICT (school_system_id,
>                                        student_id,
>                                        campus_name
>                                        ) DO UPDATE
>                                SET school_system_id = 
> excluded.school_system_id,
>                                    student_id = excluded.student_id,
>                                    campus_name = excluded.campus_name
> 
> These are the fields that shows on error when I hadn't implemented the 
> ON CONFLICT. These are the duplicate fields.
> 

-- 
Adrian Klaver
adrian.klaver@aklaver.com


pgsql-general by date:

Previous
From: Ben Hood
Date:
Subject: Re: Domain based on TIMEZONE WITH TIME ZONE
Next
From: Adrian Klaver
Date:
Subject: Re: Domain based on TIMEZONE WITH TIME ZONE