View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0006678 | SymmetricDS | Improvement | public | 2024-12-13 19:05 | 2025-03-24 18:46 |
| Reporter | pmarzullo | Assigned To | awebb | ||
| Priority | normal | ||||
| Status | acknowledged | Resolution | open | ||
| Product Version | 3.15.0 | ||||
| Target Version | 3.16.1 | ||||
| Summary | 0006678: Support INCLUDE non-key columns for indexes in Postgres | ||||
| Description | Postgres supports covering indexes, which allows the creation of a non-clustered index where the columns that are used for the index are set up in a b-tree data structure, and other columns can be included in the index without being a part of the b-tree index so that a query can be satisfied by only the index instead of going to the index and the table space. DDL Utils will need to be updated to support the INCLUDE (column list) part of the index definition. This has already been changed for SQL Server using issue 6677. | ||||
| Steps To Reproduce | https://www.postgresql.org/docs/current/sql-createindex.html Create test table. Enable DDL capture in SymmetricDS trigger.capture.ddl.changes=true Configure table for replication. Create index with INCLUDE clause. | ||||
| Tags | ddl/schema, dialect: postgresql | ||||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2024-12-13 19:05 | pmarzullo | New Issue | |
| 2024-12-13 19:05 | pmarzullo | Status | new => assigned |
| 2024-12-13 19:05 | pmarzullo | Assigned To | => pmarzullo |
| 2024-12-13 19:05 | pmarzullo | Tag Attached: ddl/schema | |
| 2024-12-13 19:05 | pmarzullo | Tag Attached: dialect: postgresql | |
| 2024-12-13 19:06 | pmarzullo | Relationship added | related to 0006677 |
| 2025-03-17 17:10 | pbelov | Target Version | 3.16.0 => 3.16.1 |
| 2025-03-24 18:46 | pbelov | Assigned To | pmarzullo => awebb |
| 2025-03-24 18:46 | pbelov | Status | assigned => acknowledged |
| 2025-03-24 18:46 | pbelov | Summary | Support include column for indexes for Postgres => Support INCLUDE non-key columns for indexes in Postgres |
| 2025-03-24 18:46 | pbelov | Steps to Reproduce Updated | View Revisions |