This is an automated email from the ASF dual-hosted git repository. ocket8888 pushed a commit to branch 5.1.x in repository https://gitbox.apache.org/repos/asf/trafficcontrol.git
commit d0ce67f37130e2f8027573c0411a42f31ef12652 Author: Hank Beatty <[email protected]> AuthorDate: Thu Feb 11 18:54:25 2021 -0500 Update add_deleted_tables.sql (#5511) The create function call was not adding the function to the public schema which was causing the subsequent "ALTER FUNCTION" call to fail. Co-authored-by: Hank Beatty <[email protected]> (cherry picked from commit 0271247fb903fba3163b3d6025f72678b32ce724) --- CHANGELOG.md | 1 + traffic_ops/app/db/migrations/2020062923101648_add_deleted_tables.sql | 2 +- 2 files changed, 2 insertions(+), 1 deletion(-) diff --git a/CHANGELOG.md b/CHANGELOG.md index 9d6b40e..54716ef 100644 --- a/CHANGELOG.md +++ b/CHANGELOG.md @@ -45,6 +45,7 @@ The format is based on [Keep a Changelog](http://keepachangelog.com/en/1.0.0/). - [#5461](https://github.com/apache/trafficcontrol/issues/5461) - Fixed steering endpoint to be ordered consistently - [#5395](https://github.com/apache/trafficcontrol/issues/5395) - Added validation to prevent changing the Type any Cache Group that is in use by a Topology - Fixed an issue with 2020082700000000_server_id_primary_key.sql trying to create multiple primary keys when there are multiple schemas. +- Fix for public schema in 2020062923101648_add_deleted_tables.sql ### Changed - Refactored the Traffic Ops Go client internals so that all public methods have a consistent behavior/implementation diff --git a/traffic_ops/app/db/migrations/2020062923101648_add_deleted_tables.sql b/traffic_ops/app/db/migrations/2020062923101648_add_deleted_tables.sql index c22a042..4f15b05 100644 --- a/traffic_ops/app/db/migrations/2020062923101648_add_deleted_tables.sql +++ b/traffic_ops/app/db/migrations/2020062923101648_add_deleted_tables.sql @@ -31,7 +31,7 @@ CREATE TABLE IF NOT EXISTS last_deleted ( -- -- Name: on_delete_current_timestamp_last_updated(); Type: FUNCTION; Schema: public; Owner: traffic_ops -- -CREATE OR REPLACE FUNCTION on_delete_current_timestamp_last_updated() +CREATE OR REPLACE FUNCTION public.on_delete_current_timestamp_last_updated() RETURNS trigger AS $$ BEGIN
