In Postgres, in order to add columns to a view/report you have to drop and recreate the view. You can’t execute the ‘create or replace view’ query if the view is used in another view.
The ‘all_errors’ report is automatically generated from error reports. So if I need to add a column to an error report, I first have to drop the ‘all_errors’ report, then drop/create the report in question.
I need a way to toggle off the regeneration of the all_errors report because it’s adding extra time to what I’m trying to do.
Please authenticate to join the conversation.
In Progress
Syniti Knowledge Platform
Migrate
5 months ago

jay.hornback@syniti.com
Get notified by email when there are changes.
In Progress
Syniti Knowledge Platform
Migrate
5 months ago

jay.hornback@syniti.com
Get notified by email when there are changes.