squirrelmaster Comments - Answer Overflow

Topics

squirrelmaster

•Created by squirrelmaster on 6/23/2024 in #help

Multiple schemas in pgroll

Thank you!

3 replies

•Created by squirrelmaster on 6/23/2024 in #help

Raw SQL references

Maybe the thing to do is to add the function after start with hard references to the new schema, and then remove the hard references after complete?

5 replies

•Created by squirrelmaster on 6/23/2024 in #help

Raw SQL references

Hmmm, looking at the raw sql restrictions, it's not possible for a function to be migrated in step with a supported operation like rename column, so a function that references a renamed column will break. Is it viable to just put all the migration's operations into a single raw sql operation, or will this cause locking and kind of defeat the purpose of pgroll?

5 replies

•Created by squirrelmaster on 6/23/2024 in #help

Raw SQL references

Oh, it seems like search path should handle this 🙂

5 replies