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 | assigned | 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 |