When Migrate generates update rules, it would be VERY useful for it to automatically alias the table, and add that alias to the columns.
See the current shell rule that gets generated:

What I’m proposing is to replace the full table with “s.” and aliasing the column as “s”

It may not seem like much, but in Postgres when there is no visual view designer, it becomes very cumbersome when you have to type out the table names for every column. And I end up repetitively aliasing and swapping in “s.” hundreds of times throughout the rules and reports.
*Similarly, any source report would get “s.” and target report would get “t.”
- And one last thing… can we add “WHERE s.zactive = true” to all update rules? I believe that’s standard methodology?
Please authenticate to join the conversation.
In Review
Syniti Knowledge Platform
Migrate
About 21 hours ago

jay.hornback@syniti.com
Get notified by email when there are changes.
In Review
Syniti Knowledge Platform
Migrate
About 21 hours ago

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