View Issue Details

IDProjectCategoryView StatusLast Update
0004524SymmetricDSNew Featurepublic2025-03-26 17:43
Reporterelong Assigned To 
Prioritynormal 
Status acknowledgedResolutionopen 
Product Version3.13.0 
Summary0004524: Add support for PostgreSQL search_path instead of target schema name
DescriptionThe 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;
Tagsdialect: postgresql

Relationships

related to 0002322 acknowledged need to be able to force sym_tables to a schema 
related to 0006779 assignedpbelov 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 

Activities

There are no notes attached to this issue.

Issue History

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