View Revisions: Issue #6779
| Summary | 0006779: Postgresql DDL trigger fails when sym_trigger_hist is located in another schema | ||
|---|---|---|---|
| Revision | 2025-03-27 21:19 by pbelov | ||
| Description | Function for DDL trigger (on Postgresql) fails when sym_trigger_hist is located in another schema. The error occurs in the function fsym_on_filtered_ddl, which implements the DDL trigger for Postgres endpoint. ERROR: relation "sym_trigger_hist" does not exist LINE 1: ...id, source_table_name from sym_trigge... ^ QUERY: select trigger_hist_id, source_table_name from sym_trigger_hist where upper(source_table_name) = upper(tableName) and inactive_time is null CONTEXT: PL/pgSQL function tds.fsym_on_all_ddl() line 25 at SQL statement |
||
| Revision | 2025-03-21 21:00 by pbelov | ||
| Description | Function for DDL trigger (on Postgresql) fails when sym_trigger_hist is located in another schema. ERROR: relation "sym_trigger_hist" does not exist LINE 1: ...id, source_table_name from sym_trigge... ^ QUERY: select trigger_hist_id, source_table_name from sym_trigger_hist where upper(source_table_name) = upper(tableName) and inactive_time is null CONTEXT: PL/pgSQL function tds.fsym_on_all_ddl() line 25 at SQL statement |
||