Hi,
I currently have a task of renaming a Vertica schema.
The problem is that this schema is being intensely used (writes / reads).
I fear that after renaming the schema, all ongoing transactions will just fail.
What happens to ongoing transactions if I run the ALTER SCHEMA RENAME TO command?
Is it possible to somehow rename the Vertica schema without interrupting current transaction, without downtime?
Thank you.
+1But of course, if the insert-select is followed by a COMMIT, in a script, and a following command wants to select from schema foo that does not exist any more, a new snapshot will be taken, and the script will fail at that point.
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
77 4th Avenue
Waltham, MA 02451 USA
