Page 1 of 1

Vertica Quick Tip: Which rows will commit?

Posted: Fri Jan 26, 2018 2:24 pm
by JimKnicely
Vertica Community Blog post authored by Jim Knicely
Did you ever update a bunch of rows in a table, then forget which ones you changed? Fearing you might have updated an incorrect record, you might have to roll back and start again. Or, in Vertica you can first check which records have been modified prior to executing a COMMIT statement!

Read more here:
https://forum.vertica.com/discussion/23 ... ill-commit