View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0004524 | SymmetricDS | New Feature | public | 2020-09-04 17:26 | 2025-03-26 17:43 |
| Reporter | elong | Assigned To | |||
| Priority | normal | ||||
| Status | acknowledged | Resolution | open | ||
| Product Version | 3.13.0 | ||||
| Summary | 0004524: Add support for PostgreSQL search_path instead of target schema name | ||||
| Description | The search_patch is a feature of PostgreSQL, where it will search the list of schemas for the table. The search_path is used for any SQL command to find tables when they are unqualified with the schema. Instead of specifying a target schema name (on the router or in a transform), the user could set the search_path. Instead of specifying the source schema name (on the trigger), the user could set the search_path. SET search_path TO myschema,public; | ||||
| Tags | dialect: postgresql | ||||
| related to | 0002322 | acknowledged | need to be able to force sym_tables to a schema | |
| related to | 0006779 | closed | pbelov | Postgresql DDL trigger fails when sym_trigger_hist is located in another schema |
| related to | 0002248 | acknowledged | Syncing H2 and postgres creates problem when source schema is given (case sensitivity) | |
| related to | 0003424 | acknowledged | Unable to uninstall SymmetricDS PostgreSQL node when using dedicated schema |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2020-09-04 17:26 | elong | New Issue | |
| 2020-09-04 17:26 | elong | Status | new => assigned |
| 2020-09-04 17:26 | elong | Assigned To | => elong |
| 2020-09-04 17:26 | elong | Tag Attached: dialect: postgresql | |
| 2020-09-04 17:26 | elong | Relationship added | related to 0002322 |
| 2021-11-02 20:52 | elong | Target Version | 3.13.0 => 3.14.0 |
| 2022-07-25 16:32 | elong | Assigned To | elong => |
| 2022-07-25 16:32 | elong | Status | assigned => new |
| 2022-07-25 16:32 | elong | Target Version | 3.14.0 => 3.14.1 |
| 2022-08-24 18:56 | elong | Target Version | 3.14.1 => 3.14.2 |
| 2022-10-03 14:40 | elong | Target Version | 3.14.2 => |
| 2023-09-13 17:39 | elong | Summary | Add support for PostgreSQL search_path => Add support for PostgreSQL search_path instead of target schema name |
| 2025-03-26 17:07 | emiller | Relationship added | related to 0006779 |
| 2025-03-26 17:07 | emiller | Status | new => acknowledged |
| 2025-03-26 17:18 | emiller | Relationship added | related to 0002248 |
| 2025-03-26 17:43 | emiller | Relationship added | related to 0003424 |