View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000377 | SymmetricDS | New Feature | public | 2011-01-12 15:17 | 2017-03-07 12:43 |
| Reporter | Assigned To | maxwellpettit | |||
| Priority | low | ||||
| Status | closed | Resolution | not fixable | ||
| Target Version | 3.8.18 | Fixed in Version | 3.8.18 | ||
| Summary | 0000377: Allow for synchronization of views | ||||
| Description | Some database systems allows triggers on views (like SQL Server). It would be nice to be able to synchronized data using views. | ||||
| Tags | No tags attached. | ||||
|
|
Add support for Postgres and possibly Sql Server. Might be as easy as making views look like tables on Postgres. Postgres 9.1+ supports triggers on views. |
|
|
I don't think this is doable the way we had hoped to implement it. We were hoping that a trigger on a view meant that if a source table gets updated, then the trigger would fire. This isn't the case. |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2012-06-18 18:11 | admin | Target Version | 3.1.0 => |
| 2014-02-04 16:02 | elong | Priority | high => low |
| 2014-02-04 16:02 | elong | Severity | minor => feature |
| 2014-02-04 16:02 | elong | Fixed in Version | 3.1.0 => |
| 2017-01-30 19:20 | chenson | Assigned To | => maxwellpettit |
| 2017-01-30 19:20 | chenson | Status | new => assigned |
| 2017-01-30 19:20 | chenson | Target Version | => 3.8.15 |
| 2017-01-30 19:22 | chenson | Note Added: 0000965 | |
| 2017-02-01 16:18 | chenson | Target Version | 3.8.15 => 3.8.16 |
| 2017-02-08 13:24 | chenson | Target Version | 3.8.16 => 3.8.17 |
| 2017-02-23 23:11 | chenson | Target Version | 3.8.17 => 3.8.18 |
| 2017-03-07 12:42 | chenson | Note Added: 0000972 | |
| 2017-03-07 12:43 | chenson | Status | assigned => closed |
| 2017-03-07 12:43 | chenson | Resolution | open => not fixable |