We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


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

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 ...