View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0005341 | SymmetricDS | New Feature | public | 2022-06-21 14:55 | 2023-05-03 13:17 |
| Reporter | elong | Assigned To | elong | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.13.0 | ||||
| Target Version | 3.13.6 | Fixed in Version | 3.13.6 | ||
| Summary | 0005341: Add system property to control use of "on conflict" on Postgres | ||||
| Description | Add 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. | ||||
| Tags | conflict manager, dialect: postgresql | ||||
|
SymmetricDS: 3.13 dbe5b521 2022-06-21 14:56:11 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 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 | ||
| 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 |