View Issue Details

IDProjectCategoryView StatusLast Update
0005341SymmetricDSNew Featurepublic2022-06-21 15:00
Reporterelong Assigned Toelong  
Prioritynormal 
Status resolvedResolutionfixed 
Product Version3.13.0 
Target Version3.13.6Fixed in Version3.13.6 
Summary0005341: Add system property to control use of "on conflict" on Postgres
DescriptionAdd system property that can be set to prevent usage of "on conflict do nothing" during inserts. To prevent the batch from rolling back, it uses "on conflict do nothing" and checks if 0 rows were insert to detect a conflict. Instead, when postgres.use.on.conflict=false, it will use the older method of insert into table select where exists. Some users might need this if they use table partitioning based on inherits and a before trigger that causes 0 rows to be returned on all operations even when successfully -- they would also need to configure a conflict with a resolution of ignore.
Tagsconflict manager, dialect: postgresql

Activities

There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.13 dbe5b521

2022-06-21 14:56:11

admin

Details Diff
0005341: Add system property to control use of "on conflict" on Postgres Affected Issues
0005341
mod - symmetric-db/src/main/java/org/jumpmind/db/platform/DmlStatementFactory.java Diff File

SymmetricDS: 3.14 567c94e2

2022-06-21 14:56:11

admin

Details Diff
0005341: Add system property to control use of "on conflict" on Postgres Affected Issues
0005341
mod - symmetric-db/src/main/java/org/jumpmind/db/platform/DmlStatementFactory.java Diff File

Issue History

Date Modified Username Field Change
2022-06-21 14:55 elong New Issue
2022-06-21 14:55 elong Status new => assigned
2022-06-21 14:55 elong Assigned To => elong
2022-06-21 14:55 elong Tag Attached: conflict manager
2022-06-21 14:55 elong Tag Attached: dialect: postgresql
2022-06-21 14:58 elong Status assigned => resolved
2022-06-21 14:58 elong Resolution open => fixed
2022-06-21 14:58 elong Fixed in Version => 3.13.6
2022-06-21 15:00 admin Changeset attached => SymmetricDS 3.13 dbe5b521
2022-06-21 15:00 admin Changeset attached => SymmetricDS 3.14 567c94e2