Does the copy_table function automatically commit a transaction to the original table?

HyeontaeJuHyeontaeJu Vertica Customer ✭
in General Discussion

Does the copy_table('original','duplicate') function automatically commit a transaction to the original table?

Answers

  • SruthiASruthiA Administrator

    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.

  • moshegmosheg Vertica Employee Administrator

    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.

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Format
SpoilerCodeQuote
Heading 2Heading 1
Emoji
:):D:(;):/:o:s:p:'(:|B):#:*<3o:)>:)
Url
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
Home • General DiscussionComment As ...