Auto Commit at the DB level?

Moderator: NorbertKrupa

Post Reply
Brett
Beginner
Beginner
Posts: 49
Joined: Fri Oct 11, 2013 1:19 am

Auto Commit at the DB level?

Post by Brett » Thu Mar 06, 2014 4:51 pm

Hi!

Is there an autocommit feature at the DB level? Or is this a feature only available with vsql?

Thank you
Top
NorbertKrupa
GURU
GURU
Posts: 527
Joined: Tue Oct 22, 2013 9:36 pm
Location: Chicago, IL
Contact:
Contact NorbertKrupa

Re: Auto Commit at the DB level?

Post by NorbertKrupa » Thu Mar 06, 2014 6:00 pm

Vertica does not have auto-commit. You can append COMMIT to your actual statement, or set it at the session:

Code: Select all

 SET SESSION AUTOCOMMIT TO ON;
Read more in the documentation.
Checkout vertica.tips for more Vertica resources.
Top
Post Reply

Return to “New to Vertica Database Administration”