cancel
Showing results for 
Search instead for 
Did you mean: 

on conflict limitaion .. partition table

SOLVED
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.

 

1 ACCEPTED SOLUTION

Accepted Solutions
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...  

 

2 REPLIES 2
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...  

 

Adventurer

Re: on conflict limitaion .. partition table

Oops, sorry.

Thank your for reply!!!