View Issue Details

IDProjectCategoryView StatusLast Update
0004524SymmetricDSNew Featurepublic2020-09-04 13:26
Reporterelong Assigned Toelong  
Prioritynormal 
Status assignedResolutionopen 
Product Version3.13.0 
Target Version3.13.0 
Summary0004524: Add support for PostgreSQL search_path
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 new need to be able to force sym_tables to a schema 

Activities

There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2020-09-04 13:26 elong New Issue
2020-09-04 13:26 elong Status new => assigned
2020-09-04 13:26 elong Assigned To => elong
2020-09-04 13:26 elong Tag Attached: dialect: postgresql
2020-09-04 13:26 elong Relationship added related to 0002322