View Issue Details

IDProjectCategoryView StatusLast Update
0005652SymmetricDSNew Featurepublic2023-04-11 15:42
Reporteremiller Assigned Toemiller  
Prioritynormal 
Status closedResolutionfixed 
Product Version3.14.3 
Target Version3.14.4Fixed in Version3.14.4 
Summary0005652: Improve SQL Server DDL triggers and add DDL triggers for Oracle and Postgres
Description- Improve the SQL Server DDL trigger by having the changes' sym_data entries use the relevant table name, trigger hist ID and channel ID rather than having them use sym_node and the config channel
- Add a parameter that controls whether the DDL trigger fires if the relevant table does not have an active sym_trigger_hist entry
- Add DDL triggers for Oracle and Postgres
TagsNo tags attached.

Relationships

related to 0005783 closedemiller SymmetricDS seems to require Postgres 11, but the docs don't reflect that 

Activities

There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.14 487d98df

2023-01-05 18:46:53

evan-miller-jumpmind

Details Diff
0005652: Improved SQL Server DDL triggers and added DDL triggers for Oracle and Postgres Affected Issues
0005652
mod - symmetric-client/src/main/java/org/jumpmind/symmetric/db/mssql/MsSqlTriggerTemplate.java Diff File
mod - symmetric-client/src/main/java/org/jumpmind/symmetric/db/oracle/OracleSymmetricDialect.java Diff File
mod - symmetric-client/src/main/java/org/jumpmind/symmetric/db/oracle/OracleTriggerTemplate.java Diff File
mod - symmetric-client/src/main/java/org/jumpmind/symmetric/db/postgresql/PostgreSqlSymmetricDialect.java Diff File
mod - symmetric-client/src/main/java/org/jumpmind/symmetric/db/postgresql/PostgreSqlTriggerTemplate.java Diff File
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/common/ParameterConstants.java Diff File
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/db/AbstractSymmetricDialect.java Diff File
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/db/AbstractTriggerTemplate.java Diff File
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/TriggerRouterService.java Diff File
mod - symmetric-core/src/main/resources/symmetric-default.properties Diff File

SymmetricDS: 3.14 2e8e9789

2023-01-06 18:15:37

evan-miller-jumpmind

Details Diff
0005652: Fixed build errors Affected Issues
0005652
mod - symmetric-client/src/main/java/org/jumpmind/symmetric/db/oracle/OracleTriggerTemplate.java Diff File

Issue History

Date Modified Username Field Change
2023-01-05 18:33 emiller New Issue
2023-01-05 18:33 emiller Status new => assigned
2023-01-05 18:33 emiller Assigned To => emiller
2023-01-05 18:47 emiller Status assigned => resolved
2023-01-05 18:47 emiller Resolution open => fixed
2023-01-05 18:47 emiller Fixed in Version => 3.14.4
2023-01-05 19:00 Changeset attached => SymmetricDS 3.14 487d98df
2023-01-06 19:00 Changeset attached => SymmetricDS 3.14 2e8e9789
2023-01-16 20:59 admin Status resolved => closed
2023-04-11 15:42 emiller Relationship added related to 0005783