in working postgresql 9.5 , wondering if possibility include names of 2 constraints in on conflict on constraint statement. sql below
insert live.table (column1, column2, column3) select distinct on (cloumn1) column1, column2, column3 stage.table on conflict on constraint live.table.pkey nothing this works fine trying include second constraint in on conflict on constraint statement. have tried below option not seem work me.
insert live.table (column1, column2, column3) select distinct on (cloumn1) column1, column2, column3 stage.table on conflict on constraint live.table.pkey, live.table.fkey1 nothing any suggestion highly appreciated.
Comments
Post a Comment