From: | David Johnston <polobo(at)yahoo(dot)com> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: How do I save my tables? |
Date: | 2013-09-17 14:55:01 |
Message-ID: | 1379429701073-5771267.post@n5.nabble.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Kimberly Israel wrote
> Thanks for your advice everyone - I'm getting ready to try it again and
> keep detailed track of the steps, but I noticed under Options->Query
> tool->Query editor that "Enable Auto ROLLBACK" is checked by default. Is
> this the opposite of auto-commit? Would unchecking it then put me into
> auto-commit?
Please follow list-norms (and others behavior) and bottom-post.
"Enable Auto ROLLBACK" only makes sense if you are in transaction (not
auto-commit) mode. It makes it so that "transaction is aborted...." message
does not appear since as soon as you have an error the software issues a
ROLLBACK for you.
Still, unless you are constantly re-creating the tables in question whenever
you cause an error those tables should have been committed at some point.
I also do not know if that option is independent of the option to use
auto-commit...
David J.
--
View this message in context: http://postgresql.1045698.n5.nabble.com/How-do-I-save-my-tables-tp5771217p5771267.html
Sent from the PostgreSQL - novice mailing list archive at Nabble.com.
From | Date | Subject | |
---|---|---|---|
Next Message | Kimberly Israel | 2013-09-17 15:25:17 | Re: How do I save my tables? |
Previous Message | Kimberly Israel | 2013-09-17 14:40:48 | Re: How do I save my tables? |