View Issue Details

IDProjectCategoryView StatusLast Update
0005820SymmetricDSNew Featurepublic2023-05-03 16:00
Reportercquamme Assigned Tocquamme  
Status closedResolutionfixed 
Product Version3.12.0 
Target Version3.12.23Fixed in Version3.12.23 
Summary0005820: 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.

This was fixed in issue 0005341 and this issue is being created as a patch for 3.12.x versions.
TagsNo tags attached.


related to 0005341 closedelong Add system property to control use of "on conflict" on Postgres 



2023-05-03 13:19

developer   ~0002311

Can put postgres.use.on.conflict=false into conf/ or set it as a system property on command line to java in conf/sym_service.conf.

Related Changesets

SymmetricDS: 3.12 4b88e535

2023-05-03 15:04:50


Details Diff
0005820: System property to control use of "on conflict" on Postgres Affected Issues
mod - symmetric-db/src/main/java/org/jumpmind/db/platform/ Diff File

Issue History

Date Modified Username Field Change
2023-05-03 13:16 cquamme New Issue
2023-05-03 13:16 cquamme Status new => assigned
2023-05-03 13:16 cquamme Assigned To => cquamme
2023-05-03 13:17 cquamme Relationship added related to 0005341
2023-05-03 13:19 cquamme Note Added: 0002311
2023-05-03 15:11 cquamme Status assigned => resolved
2023-05-03 15:11 cquamme Resolution open => fixed
2023-05-03 15:11 cquamme Fixed in Version => 3.12.23
2023-05-03 16:00 cquamme Changeset attached => SymmetricDS 3.12 4b88e535
2023-05-12 19:43 admin Status resolved => closed