Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!
Does the copy_table function automatically commit a transaction to the original table?
Does the copy_table('original','duplicate') function automatically commit a transaction to the original table?
0
Leave a Comment
Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.
Answers
Once you run copy_table, original and duplicate tables are treated seperately. so when you commit a transaction on the duplicate table, it will not change anything in original table.
In addition, the copy_table statement initiate a COMMIT to any previous statement in that session even if the session AUTOCOMMIT is set to OFF.