View Issue Details

IDProjectCategoryView StatusLast Update
0005341SymmetricDSNew Featurepublic2023-05-03 13:17
Reporterelong Assigned Toelong  
Prioritynormal 
Status closedResolutionfixed 
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

Relationships

related to 0005820 closedcquamme System property to control use of "on conflict" on Postgres 
related to 0004975 closedelong insert with on conflict clause cannot be used with table that has insert or update rules 
related to 0005045 closedelong Errors in "ON CONFLICT " - need a new parameter 

Activities

elong

2022-07-27 15:17

developer   ~0002112

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

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
2022-07-12 20:01 admin Status resolved => closed
2022-07-27 15:16 elong Relationship added related to 0004975
2022-07-27 15:16 elong Relationship added related to 0005045
2022-07-27 15:17 elong Note Added: 0002112
2023-05-03 13:17 cquamme Relationship added related to 0005820