[
https://issues.apache.org/jira/browse/AIRFLOW-4734?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17189880#comment-17189880
]
ASF GitHub Bot commented on AIRFLOW-4734:
-----------------------------------------
sahilthapar commented on pull request #8625:
URL: https://github.com/apache/airflow/pull/8625#issuecomment-686296002
The upsert functionality doesn't support "Overriding system value" for
identity columns, any planned support?
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
[email protected]
> Upsert functionality for PostgresHook.insert_rows()
> ---------------------------------------------------
>
> Key: AIRFLOW-4734
> URL: https://issues.apache.org/jira/browse/AIRFLOW-4734
> Project: Apache Airflow
> Issue Type: Improvement
> Components: hooks
> Affects Versions: 1.10.3
> Reporter: William Tran
> Assignee: William Tran
> Priority: Minor
> Labels: features
> Fix For: 2.0.0
>
> Original Estimate: 48h
> Remaining Estimate: 48h
>
> PostgresHook's parent class, DbApiHook, implements upsert in its
> insert_rows() method with the replace=True flag. However, the underlying
> generated SQL is specific to MySQL's "REPLACE INTO" syntax and is not
> applicable to Postgres.
> I'd like to override this method in PostgresHook to implement the "INSERT ...
> ON CONFLICT DO UPDATE" syntax (new since Postgres 9.5)
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
