on conflict limitaion .. partition table

SOLVED
Highlighted
Adventurer

on conflict limitaion .. partition table

I am converting ORACLE MERGE SQL into ppas sql.

 

insert ...on conflict.   

This  sql  statement NOT working on PARTITION TABLE.

 

but

with  x as (update...returing)...insert...

This  sql  statement works good on PARTITION TABLE.

 

I think that "insert..conflict limitation" should be written  in postgresql manual.

 

sorry for poor english.

 

Archived Discussions


Effective March 31st, we will no longer engage on PostgresRocks.


How to engage with us further?


  • Thought Leadership: EDB Blogs

  • Tips and Tricks: Postgres Tutorials

  • Customer Support: Create a Case Please note: Only customers with an active EDB support subscription and support portal authorization can create support ticket

  • Engage on Stackoverflow While engaging on Stackoverflow tag the question with EDB or EnterpriseDB.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Moderator

Re: on conflict limitaion .. partition table

Hi,

This is already documented,

"The PostgreSQL 9.5 INSERT… ON CONFLICT DO NOTHING/UPDATE clause (commonly known as UPSERT) is not supported 
on Oracle-styled partitioned tables. If you include the ON CONFLICT DO NOTHING/UPDATE clause when invoking
the INSERT command to add data to a partitioned table, the server will return an error."

https://www.enterprisedb.com/docs/en/9.5/oracompat/Database_Compatibility_for_Oracle_Developers_Guid...  

 

View solution in original post

2 REPLIES 2
Highlighted
Moderator

Re: on conflict limitaion .. partition table

Hi,

This is already documented,

"The PostgreSQL 9.5 INSERT… ON CONFLICT DO NOTHING/UPDATE clause (commonly known as UPSERT) is not supported 
on Oracle-styled partitioned tables. If you include the ON CONFLICT DO NOTHING/UPDATE clause when invoking
the INSERT command to add data to a partitioned table, the server will return an error."

https://www.enterprisedb.com/docs/en/9.5/oracompat/Database_Compatibility_for_Oracle_Developers_Guid...  

 

View solution in original post

Highlighted
Adventurer

Re: on conflict limitaion .. partition table

Oops, sorry.

Thank your for reply!!!

© 2019 EnterpriseDB Corporation. All rights reserved.   |   Privacy Policy   |  Terms of Use   |   Trademarks