Re: ROLLBACK syntax error in pgadmin4

<div style="color:#000; background-color:#fff; font-family:Courier New, courier, monaco, monospace,
sans-serif;font-size:16px"><divid="yui_3_16_0_ym19_1_1480456117764_25736"><b>Malik,</b></div><div
id="yui_3_16_0_ym19_1_1480456117764_25737"><b><br/></b></div><div dir="ltr"
id="yui_3_16_0_ym19_1_1480456117764_25738"><bid="yui_3_16_0_ym19_1_1480456117764_26624">I was not blaming you for
postingto PgAdmin, I was just trying to advise you and direct you to the proper <br /></b></div><div dir="ltr"
id="yui_3_16_0_ym19_1_1480456117764_25878"><bid="yui_3_16_0_ym19_1_1480456117764_26399">forum. Please do not be so
defensive.As to determining whether it is a PgAdmin error or a PostgreSQL error, that is pretty simple. If a "feature"
ofPgAdmin is not working properly, then it is a PgAdmin error. But if you get a SQL error after running a SQL query,
thenit has to be PostgreSQL.<br /></b></div><div id="yui_3_16_0_ym19_1_1480456117764_25729"><b><span><br
/></span></b></div><divid="yui_3_16_0_ym19_1_1480456117764_26663"><b id="yui_3_16_0_ym19_1_1480456117764_26662"><span
id="yui_3_16_0_ym19_1_1480456117764_26661">Yes,you did give the O/S and PostgreSQL "major" version, but the minor
versionof PostgreSQL can be <br /></span></b></div><div dir="ltr" id="yui_3_16_0_ym19_1_1480456117764_26666"><b
id="yui_3_16_0_ym19_1_1480456117764_26665"><spanid="yui_3_16_0_ym19_1_1480456117764_26664">critical in some cases, as
theyminor versions contain fixes for bugs that may or may not have something <br /></span></b></div><div dir="ltr"
id="yui_3_16_0_ym19_1_1480456117764_26667"><b><span>todo with problem you seek help for. <br /></span></b></div><div
dir="ltr"id="yui_3_16_0_ym19_1_1480456117764_26668"><b><span><br /></span></b></div><div dir="ltr"
id="yui_3_16_0_ym19_1_1480456117764_26671"><bid="yui_3_16_0_ym19_1_1480456117764_26670"><span
id="yui_3_16_0_ym19_1_1480456117764_26669">Errorsby themself may or may not be explained. That is why it is very
importantto include a script</span></b></div><div dir="ltr" id="yui_3_16_0_ym19_1_1480456117764_26672"><b><span>that
willduplicate the error. If you go to a doctor and tell him you have a pain, do you expect him to <br
/></span></b></div><divdir="ltr" id="yui_3_16_0_ym19_1_1480456117764_26771"><b><span>tell you the cause right away, or
wouldyou understand if he asks you what led up to the pain? <br /></span></b></div><div dir="ltr"
id="yui_3_16_0_ym19_1_1480456117764_26673"><b><span><br/></span></b></div><div dir="ltr"
id="yui_3_16_0_ym19_1_1480456117764_26674"><bid="yui_3_16_0_ym19_1_1480456117764_26997"><span
id="yui_3_16_0_ym19_1_1480456117764_26996">Yes,I am a volunteer. In fact, I am a retired PostgreSQL DBA. Hopefully you
willnow understand the</span></b></div><div dir="ltr" id="yui_3_16_0_ym19_1_1480456117764_26998"><b><span>difference
betweena transaction and a stand alone query. Good luck.</span></b></div><div
id="yui_3_16_0_ym19_1_1480456117764_25762"> </div><divclass="signature" id="yui_3_16_0_ym19_1_1480456117764_25740"><div
id="RTEContent"><fontsize="4"><span style="font-weight:bold;font-family:arial;color:rgb(0, 0, 255);">Melvin Davidson
</span></font><br/><font size="3">     Cell 720-320-0155 <br /></font><font id="yui_3_16_0_ym19_1_1480456117764_25760"
size="3"style="font-weight:bold;"><span id="yui_3_16_0_ym19_1_1480456117764_25761" style="color:rgb(128, 0, 255);">I
reservethe right to fantasize.  Whether or not you </span><br style="color:rgb(128, 0, 255);" /><span
id="yui_3_16_0_ym19_1_1480456117764_25759"style="color:rgb(128, 0, 255);">wish to share my fantasy is entirely up to
you.</span><img data-id="53bf0ce2-e2c8-7b6a-7ce8-436c79183efa"
src="http://us.i1.yimg.com/us.yimg.com/i/mesg/tsmileys2/01.gif"style="color:rgb(128, 0, 255);" /><br /></font><font
id="yui_3_16_0_ym19_1_1467319472979_3360"size="3" style="font-weight:bold;">www.youtube.com/unusedhero/videos<br
/></font><fontsize="3"><span style="font-weight:bold;font-family:courier;">Folk Alley - All Folk - 24 Hours a day
</span><spanstyle="font-weight:bold;font-family:courier;"><br />www.folkalley.com<br /><br
/></span></font></div></div><divclass="qtdSeparateBR"><br /><br /></div><div class="yahoo_quoted"
id="yui_3_16_0_ym19_1_1480456117764_25745"style="display: block;"><div id="yui_3_16_0_ym19_1_1480456117764_25744"
style="font-family:Courier New, courier, monaco, monospace, sans-serif; font-size: 16px;"><div
id="yui_3_16_0_ym19_1_1480456117764_25743"style="font-family: HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida
Grande,sans-serif; font-size: 16px;"><div dir="ltr" id="yui_3_16_0_ym19_1_1480456117764_25742"><font face="Arial"
size="2"><hrsize="1" /><b><span style="font-weight:bold;">From:</span></b> Malik Rumi <malik.a.rumi@gmail.com><br
/><b><spanstyle="font-weight: bold;">To:</span></b> Melvin Davidson <melvin6925@yahoo.com> <br /><b><span
style="font-weight:bold;">Cc:</span></b> PgAdmin Support <pgadmin-support@postgresql.org><br /><b><span
style="font-weight:bold;">Sent:</span></b> Tuesday, November 29, 2016 5:14 PM<br /><b><span style="font-weight:
bold;">Subject:</span></b>Re: [pgadmin-support] ROLLBACK syntax error in pgadmin4<br /></font></div><div
class="y_msg_container"id="yui_3_16_0_ym19_1_1480456117764_25746"><br /><div id="yiv2072469051"><div
id="yui_3_16_0_ym19_1_1480456117764_25754"><divdir="ltr" id="yui_3_16_0_ym19_1_1480456117764_25753"><div
id="yui_3_16_0_ym19_1_1480456117764_25752"><divid="yui_3_16_0_ym19_1_1480456117764_25751"><div
id="yui_3_16_0_ym19_1_1480456117764_25750"><divid="yui_3_16_0_ym19_1_1480456117764_25749"><div
id="yui_3_16_0_ym19_1_1480456117764_25748"><divid="yui_3_16_0_ym19_1_1480456117764_25747">Ok, I am not trying to be
difficult.I am trying to understand. If that sounds defensive, it's because of prior experience on Stack Overflow,
wherethe "experts" tend to be snarky, IMHO.<br clear="none" /><br clear="none" /></div>I did all of this in PGAdmin4,
sothat is why I posted here. How would I determine what is a PGAdmin4 issue and what is not?<br clear="none" /><br
clear="none"/></div>I <b>did</b> tell you my OS in the <i id="yui_3_16_0_ym19_1_1480456117764_25755">very first line of
myvery first post</i> on this issue. I also told you my postgres version <u><i>on that same line</i></u>. When you say
'exact',do you mean 9.4.8, instead of just 9.4?<br clear="none" /><br clear="none" /></div>True enough, I did not give
youthe entire SQL, but I did give you the error, which quoted what I assumed were the relevant portions of the SQL. I'm
sorryif that wasn't enough. <br clear="none" /><br clear="none" /></div>I gave you the background on what I had done to
finda solution on my own. I also asked a lot of questions which I hoped would clarify my understanding of the problem,
butthey have not been addressed. <br clear="none" /><br clear="none" /></div>All in all, I thought I was being pretty
verboseand specific. Maybe too much so. When you put together the lack of response to my specific questions, and asking
forOS and PG version info I already gave, well, it's kinda discouraging. But it's a free service, and I assume you are
avolunteer with a life and issues of your own. At least you responded, and fairly soon. A lot of people don't even get
that.<br clear="none" /><br clear="none" /></div>I'm going to restart and hope for the best. I've learned that fsync is
supposedto be on by default, so if the uncheck of autocommit did what it was supposed to do, I should be fine. If not,
Ihave a backup. I just wanted to learn. <br clear="none" /></div><div class="yiv2072469051yqt9980183305"
id="yiv2072469051yqt10485"><divclass="yiv2072469051gmail_extra" id="yui_3_16_0_ym19_1_1480456117764_25940"><br
clear="none"/><div class="yiv2072469051gmail_quote" id="yui_3_16_0_ym19_1_1480456117764_25939">On Tue, Nov 29, 2016 at
12:59PM, Melvin Davidson <span dir="ltr"><<a href="mailto:melvin6925@yahoo.com" rel="nofollow" shape="rect"
target="_blank"ymailto="mailto:melvin6925@yahoo.com">melvin6925@yahoo.com</a>></span> wrote:<br clear="none"
/><blockquoteclass="yiv2072469051gmail_quote" id="yui_3_16_0_ym19_1_1480456117764_25938" style="margin:0 0 0
.8ex;border-left:1px#ccc solid;padding-left:1ex;"><div id="yui_3_16_0_ym19_1_1480456117764_25937"><div
id="yui_3_16_0_ym19_1_1480456117764_25936"style="color:#000;background-color:#fff;font-family:Courier New, courier,
monaco,monospace, sans-serif;font-size:16px;"><div
id="yiv2072469051m_1911922675164783267yui_3_16_0_1_1480447941789_21878"><b>Malik,</b></div><div
id="yiv2072469051m_1911922675164783267yui_3_16_0_1_1480447941789_21877"><b><brclear="none" /></b></div><div
id="yiv2072469051m_1911922675164783267yui_3_16_0_1_1480447941789_21936"><b
id="yiv2072469051m_1911922675164783267yui_3_16_0_1_1480447941789_22068">Firstthings first.</b></div><div
id="yiv2072469051m_1911922675164783267yui_3_16_0_1_1480447941789_21876"><b
id="yiv2072469051m_1911922675164783267yui_3_16_0_1_1480447941789_22067">1.This is not the correct forum for this
problem.</b></div><divid="yiv2072469051m_1911922675164783267yui_3_16_0_1_1480447941789_21811"><b><br clear="none"
/></b></div><divdir="ltr" id="yiv2072469051m_1911922675164783267yui_3_16_0_1_1480447941789_21812"><b
id="yiv2072469051m_1911922675164783267yui_3_16_0_1_1480447941789_22663">PgAdminis a utility for managing
PostgreSQL.</b></div><divdir="ltr" id="yiv2072469051m_1911922675164783267yui_3_16_0_1_1480447941789_21937"><b><br
clear="none"/></b></div><div dir="ltr" id="yiv2072469051m_1911922675164783267yui_3_16_0_1_1480447941789_21938"><b
id="yiv2072469051m_1911922675164783267yui_3_16_0_1_1480447941789_22066">Youare better off re-submitting this problem to
pgsql-general</b><bid="yiv2072469051m_1911922675164783267yui_3_16_0_1_1480447941789_22417">@<a
href="http://postgresql.org/"rel="nofollow" shape="rect" target="_blank">postgresql.org</a></b></div><div dir="ltr"
id="yiv2072469051m_1911922675164783267yui_3_16_0_1_1480447941789_21991"><b
id="yiv2072469051m_1911922675164783267yui_3_16_0_1_1480447941789_22065">butyou stand a better chance if you also
include</b></div><divdir="ltr" id="yiv2072469051m_1911922675164783267yui_3_16_0_1_1480447941789_21992"><b
id="yiv2072469051m_1911922675164783267yui_3_16_0_1_1480447941789_22416">A.O/S</b></div><div dir="ltr"
id="yiv2072469051m_1911922675164783267yui_3_16_0_1_1480447941789_22022"><b
id="yiv2072469051m_1911922675164783267yui_3_16_0_1_1480447941789_22418">B.<font color="#cd232c"
id="yiv2072469051m_1911922675164783267yui_3_16_0_1_1480447941789_22569">Exactversion of PostgreSQL</font></b></div><div
dir="ltr"id="yiv2072469051m_1911922675164783267yui_3_16_0_1_1480447941789_22109"><b
id="yiv2072469051m_1911922675164783267yui_3_16_0_1_1480447941789_22112">C.<font color="#cd232c">SQL code to reproduce
theproblem.</font><br clear="none" /></b></div><div
id="yiv2072469051m_1911922675164783267yui_3_16_0_1_1480447941789_21765"><span><brclear="none" /></span></div><div
dir="ltr"id="yiv2072469051m_1911922675164783267yui_3_16_0_1_1480447941789_22211"><b
id="yiv2072469051m_1911922675164783267yui_3_16_0_1_1480447941789_22328"><span
id="yiv2072469051m_1911922675164783267yui_3_16_0_1_1480447941789_22208">Asfor "</span>ERROR: current transaction is
aborted,commands ignored until end of transaction block"</b></div><div dir="ltr"
id="yiv2072469051m_1911922675164783267yui_3_16_0_1_1480447941789_22212"><b
id="yiv2072469051m_1911922675164783267yui_3_16_0_1_1480447941789_22327">Itmeans all commands from BEGIN; until the
erroroccurs are rolled back. No further commands</b></div><div dir="ltr"
id="yiv2072469051m_1911922675164783267yui_3_16_0_1_1480447941789_22301"><b
id="yiv2072469051m_1911922675164783267yui_3_16_0_1_1480447941789_22662">afterthe error occurs are executed.<br
clear="none"/></b></div><div id="yiv2072469051m_1911922675164783267yui_3_16_0_1_1480447941789_21760"> </div><div
class="yiv2072469051m_1911922675164783267signature"
id="yiv2072469051m_1911922675164783267yui_3_16_0_1_1480447941789_21751"><div
id="yiv2072469051m_1911922675164783267RTEContent"><fontsize="4"><span
style="font-weight:bold;font-family:arial;color:rgb(0,0,255);">MelvinDavidson </span></font><br clear="none" /><span
class="yiv2072469051"><font id="yiv2072469051m_1911922675164783267yui_3_16_0_1_1480447941789_21750" size="3"
style="font-weight:bold;"><spanid="yiv2072469051m_1911922675164783267yui_3_16_0_1_1480447941789_21759"
style="color:rgb(128,0,255);">Ireserve the right to fantasize.  Whether or not you </span><br clear="none"
style="color:rgb(128,0,255);"/><span id="yiv2072469051m_1911922675164783267yui_3_16_0_1_1480447941789_21749"
style="color:rgb(128,0,255);">wishto share my fantasy is entirely up to you. </span><img
data-id="da995f33-87fb-ef8d-aeba-686363b03f1b"src="http://us.i1.yimg.com/us.yimg.com/i/mesg/tsmileys2/01.gif"
style="color:rgb(128,0,255);"/><br clear="none" /></font><font
id="yiv2072469051m_1911922675164783267yui_3_16_0_ym19_1_1467319472979_3360"size="3" style="font-weight:bold;"><a
href="http://www.youtube.com/unusedhero/videos"rel="nofollow" shape="rect" target="_blank">www.youtube.com/unusedhero/
videos</a><brclear="none" /></font><font id="yiv2072469051m_1911922675164783267yui_3_16_0_1_1480447941789_21758"
size="3"><spanid="yiv2072469051m_1911922675164783267yui_3_16_0_1_1480447941789_21757"
style="font-weight:bold;font-family:courier;">FolkAlley - All Folk - 24 Hours a day </span><span
id="yiv2072469051m_1911922675164783267yui_3_16_0_1_1480447941789_22621"
style="font-weight:bold;font-family:courier;"><brclear="none" /><a href="http://www.folkalley.com/" rel="nofollow"
shape="rect"target="_blank">www.folkalley.com</a><br clear="none" /><br clear="none"
/></span></font></span></div></div><divclass="yiv2072469051m_1911922675164783267qtdSeparateBR"
id="yiv2072469051m_1911922675164783267yui_3_16_0_1_1480447941789_22107"><brclear="none" /><br clear="none" /></div><div
class="yiv2072469051m_1911922675164783267yahoo_quoted"
id="yiv2072469051m_1911922675164783267yui_3_16_0_1_1480447941789_22103"style="display:block;"><div
id="yiv2072469051m_1911922675164783267yui_3_16_0_1_1480447941789_22102"style="font-family:Courier New, courier, monaco,
monospace,sans-serif;font-size:16px;"><div id="yiv2072469051m_1911922675164783267yui_3_16_0_1_1480447941789_22101"
style="font-family:HelveticaNeue,Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:16px;"><div
dir="ltr"id="yiv2072469051m_1911922675164783267yui_3_16_0_1_1480447941789_22194"><font face="Arial"
id="yiv2072469051m_1911922675164783267yui_3_16_0_1_1480447941789_22624"size="2"><span class="yiv2072469051">
</span></font><hrid="yiv2072469051m_1911922675164783267yui_3_16_0_1_1480447941789_22623" size="1" /><b><span
style="font-weight:bold;">From:</span></b>Malik Rumi <<a href="mailto:malik.a.rumi@gmail.com" rel="nofollow"
shape="rect"target="_blank" ymailto="mailto:malik.a.rumi@gmail.com">malik.a.rumi@gmail.com</a>><br clear="none"
/><b><spanstyle="font-weight:bold;">To:</span></b> Melvin Davidson <<a href="mailto:melvin6925@yahoo.com"
rel="nofollow"shape="rect" target="_blank" ymailto="mailto:melvin6925@yahoo.com">melvin6925@yahoo.com</a>> <br
clear="none"/><b><span style="font-weight:bold;">Cc:</span></b> pgAdmin Support <<a
href="mailto:pgadmin-support@postgresql.org"rel="nofollow" shape="rect" target="_blank"
ymailto="mailto:pgadmin-support@postgresql.org">pgadmin-support@postgresql.org</a>><br clear="none" /><b><span
style="font-weight:bold;">Sent:</span></b>Tuesday, November 29, 2016 2:50 PM<br clear="none" /><b><span
style="font-weight:bold;">Subject:</span></b>Re: [pgadmin-support] ROLLBACK syntax error in pgadmin4<br clear="none"
/></div><divclass="yiv2072469051m_1911922675164783267y_msg_container"
id="yiv2072469051m_1911922675164783267yui_3_16_0_1_1480447941789_22100"><brclear="none" /><div
id="yiv2072469051m_1911922675164783267yiv2305844011"><div
id="yiv2072469051m_1911922675164783267yui_3_16_0_1_1480447941789_22099"><spanclass="yiv2072469051"></span><div
dir="ltr"id="yiv2072469051m_1911922675164783267yui_3_16_0_1_1480447941789_22098"><div
id="yiv2072469051m_1911922675164783267yui_3_16_0_1_1480447941789_22097"><div
id="yiv2072469051m_1911922675164783267yui_3_16_0_1_1480447941789_22096"><div
id="yiv2072469051m_1911922675164783267yui_3_16_0_1_1480447941789_22095">Thankyou. However...<br clear="none" /><br
clear="none"/><div id="yiv2072469051m_1911922675164783267yui_3_16_0_1_1480447941789_22094"
style="margin-left:40px;">ERROR:current transaction is aborted, commands ignored until end of transaction block<br
clear="none"/></div><br clear="none" /></div>I'm not even sure what this means. Which transaction is it referring to?
Therollback or the update?<br clear="none" /></div>What is the error and how do I fix it? What is meant by
"<i><u>until</u></i>end of transaction block"? Does that mean the entire transaction block, or that something might
happenafter the end of this block?<br clear="none" /><br clear="none" /></div><div
id="yiv2072469051m_1911922675164783267yui_3_16_0_1_1480447941789_22104">Idid some more googling, and found this from
thepostgresql list:<br clear="none" /><pre id="yiv2072469051m_1911922675164783267yui_3_16_0_1_1480447941789_22139"
style="margin-left:40px;">Ifthat's what you're getting, the problem was with an earlier command  
that returned an error you didn't notice, not with the command you just
ran. <a href="https://www.postgresql.org/message-id/4CAB085C.5030106@postnewspapers.com.au"
id="yiv2072469051m_1911922675164783267yui_3_16_0_1_1480447941789_22140"rel="nofollow" shape="rect"
target="_blank">https://www.postgresql.org/message-id/4CAB085C.5030106@ postnewspapers.com.au</a> </pre>I suppose that
makessense and applies here, since I came here asking about two consecutive syntax errors in the first place. But I
stilldon't know how to safely back out of this situation. Any further advice? Anyone?<br clear="none" /></div><div
id="yiv2072469051m_1911922675164783267yui_3_16_0_1_1480447941789_22145"><brclear="none" /></div>p.s. - I said I had PG
9.4.I assumed everyone would know that meant Postgresql 9.4<br clear="none" /></div><div
class="yiv2072469051m_1911922675164783267yiv2305844011yqt1358800897"
id="yiv2072469051m_1911922675164783267yiv2305844011yqt78314"><div
class="yiv2072469051m_1911922675164783267yiv2305844011gmail_extra"
id="yiv2072469051m_1911922675164783267yui_3_16_0_1_1480447941789_22146"><brclear="none" /><div
class="yiv2072469051m_1911922675164783267yiv2305844011gmail_quote"
id="yiv2072469051m_1911922675164783267yui_3_16_0_1_1480447941789_22149"><spanclass="yiv2072469051">On Tue, Nov 29, 2016
at10:24 AM, Melvin Davidson <span dir="ltr"
id="yiv2072469051m_1911922675164783267yui_3_16_0_1_1480447941789_22148"><<ahref="mailto:melvin6925@yahoo.com"
id="yiv2072469051m_1911922675164783267yui_3_16_0_1_1480447941789_22147"rel="nofollow" shape="rect" target="_blank"
ymailto="mailto:melvin6925@yahoo.com">melvin6925@yahoo.com</a>></span>wrote:<br clear="none" /></span><blockquote
class="yiv2072469051m_1911922675164783267yiv2305844011gmail_quote"
id="yiv2072469051m_1911922675164783267yui_3_16_0_1_1480447941789_22153"style="margin:0 0 0 .8ex;border-left:1px #ccc
solid;padding-left:1ex;"><divid="yiv2072469051m_1911922675164783267yui_3_16_0_1_1480447941789_22152"><div
id="yiv2072469051m_1911922675164783267yui_3_16_0_1_1480447941789_22151"
style="color:#000;background-color:#fff;font-family:CourierNew, courier, monaco, monospace,
sans-serif;font-size:16px;"><spanclass="yiv2072469051"></span><div
id="yiv2072469051m_1911922675164783267yiv2305844011m_5682970348618810673yui_3_16_0_1_1480442930679_8438"><b
id="yiv2072469051m_1911922675164783267yui_3_16_0_1_1480447941789_22150">Theproblem is, ROLLBACK requires a transaction.
Soto use it properly you need to <br clear="none" /></b></div><div dir="ltr"
id="yiv2072469051m_1911922675164783267yiv2305844011m_5682970348618810673yui_3_16_0_1_1480442930679_8400"><b>startwith a
BEGINstatement.</b></div><div
id="yiv2072469051m_1911922675164783267yiv2305844011m_5682970348618810673yui_3_16_0_1_1480442930679_8439"><b><br
clear="none"/></b></div><div
id="yiv2072469051m_1911922675164783267yiv2305844011m_5682970348618810673yui_3_16_0_1_1480442930679_8387"><b>eg:</b></div><div
id="yiv2072469051m_1911922675164783267yiv2305844011m_5682970348618810673yui_3_16_0_1_1480442930679_8399"><b><br
clear="none"/></b></div><div
id="yiv2072469051m_1911922675164783267yiv2305844011m_5682970348618810673yui_3_16_0_1_1480442930679_8375"><b>BEGIN;</b></div><div
id="yiv2072469051m_1911922675164783267yiv2305844011m_5682970348618810673yui_3_16_0_1_1480442930679_8347"><b
id="yiv2072469051m_1911922675164783267yiv2305844011m_5682970348618810673yui_3_16_0_1_1480442930679_8847">your_statements;</b></div><div
id="yiv2072469051m_1911922675164783267yiv2305844011m_5682970348618810673yui_3_16_0_1_1480442930679_8363"><b>ROLLBACK;<br
clear="none"/></b></div><div
id="yiv2072469051m_1911922675164783267yiv2305844011m_5682970348618810673yui_3_16_0_1_1480442930679_8313"><b><span><br
clear="none"/></span></b></div><div
id="yiv2072469051m_1911922675164783267yiv2305844011m_5682970348618810673yui_3_16_0_1_1480442930679_8630"><b
id="yiv2072469051m_1911922675164783267yiv2305844011m_5682970348618810673yui_3_16_0_1_1480442930679_8848"><a
class="yiv2072469051m_1911922675164783267yiv2305844011m_5682970348618810673edited-link-editor"
href="https://www.postgresql.org/docs/9.4/static/sql-begin.html"
id="yiv2072469051m_1911922675164783267yiv2305844011m_5682970348618810673yui_3_16_0_1_1480442930679_8631"rel="nofollow"
shape="rect"target="_blank">https://www.postgresql.org/ docs/9.4/static/sql-begin.html<br clear="none"
/></a></b></div><div
id="yiv2072469051m_1911922675164783267yiv2305844011m_5682970348618810673yui_3_16_0_1_1480442930679_8629"><b><br
clear="none"/></b></div><div
id="yiv2072469051m_1911922675164783267yiv2305844011m_5682970348618810673yui_3_16_0_1_1480442930679_8850"><b
id="yiv2072469051m_1911922675164783267yiv2305844011m_5682970348618810673yui_3_16_0_1_1480442930679_8849"><a
class="yiv2072469051m_1911922675164783267yiv2305844011m_5682970348618810673edited-link-editor"
href="https://www.postgresql.org/docs/9.4/static/sql-rollback.html"
id="yiv2072469051m_1911922675164783267yiv2305844011m_5682970348618810673yui_3_16_0_1_1480442930679_8786"rel="nofollow"
shape="rect"target="_blank">https://www.postgresql.org/ docs/9.4/static/sql-rollback. html</a></b></div><div dir="ltr"
id="yiv2072469051m_1911922675164783267yiv2305844011m_5682970348618810673yui_3_16_0_1_1480442930679_8851"><b><a
class="yiv2072469051m_1911922675164783267yiv2305844011m_5682970348618810673edited-link-editor"
href="https://www.postgresql.org/docs/9.4/static/sql-rollback.html"
id="yiv2072469051m_1911922675164783267yiv2305844011m_5682970348618810673yui_3_16_0_1_1480442930679_8786"rel="nofollow"
shape="rect"target="_blank"><br clear="none" /></a></b></div><div
id="yiv2072469051m_1911922675164783267yiv2305844011m_5682970348618810673yui_3_16_0_1_1480442930679_8314"><divdir="ltr"
id="yiv2072469051m_1911922675164783267yiv2305844011m_5682970348618810673yui_3_16_0_1_1480442930679_8853"><b
id="yiv2072469051m_1911922675164783267yiv2305844011m_5682970348618810673yui_3_16_0_1_1480442930679_8852">fyi,in the
future,it is always a good idea to include the PostgreSQL version.</b></div><div dir="ltr"
id="yiv2072469051m_1911922675164783267yiv2305844011m_5682970348618810673yui_3_16_0_1_1480442930679_8854"><b><br
clear="none"/></b></div></div><div
class="yiv2072469051m_1911922675164783267yiv2305844011m_5682970348618810673signature"
id="yiv2072469051m_1911922675164783267yiv2305844011m_5682970348618810673yui_3_16_0_1_1480442930679_8318"><div
id="yiv2072469051m_1911922675164783267yiv2305844011m_5682970348618810673RTEContent"><font
id="yiv2072469051m_1911922675164783267yiv2305844011m_5682970348618810673yui_3_16_0_1_1480442930679_8502"size="4"><span
id="yiv2072469051m_1911922675164783267yiv2305844011m_5682970348618810673yui_3_16_0_1_1480442930679_8501"
style="font-weight:bold;font-family:arial;color:rgb(0,0,255);">MelvinDavidson </span></font><br clear="none" /><font
id="yiv2072469051m_1911922675164783267yiv2305844011m_5682970348618810673yui_3_16_0_1_1480442930679_8671"size="3"><br
clear="none"/></font><span class="yiv2072469051"><font
id="yiv2072469051m_1911922675164783267yiv2305844011m_5682970348618810673yui_3_16_0_1_1480442930679_8441"size="3"
style="font-weight:bold;"><span
id="yiv2072469051m_1911922675164783267yiv2305844011m_5682970348618810673yui_3_16_0_1_1480442930679_8440"
style="color:rgb(128,0,255);">Ireserve the right to fantasize.  Whether or not you </span><br clear="none"
style="color:rgb(128,0,255);"/><span
id="yiv2072469051m_1911922675164783267yiv2305844011m_5682970348618810673yui_3_16_0_1_1480442930679_8457"
style="color:rgb(128,0,255);">wishto share my fantasy is entirely up to you. </span><img
data-id="cf8fe00a-4afb-14ce-2413-d30aa00959cc"src="http://us.i1.yimg.com/us.yimg.com/i/mesg/tsmileys2/01.gif"
style="color:rgb(128,0,255);"/><br clear="none" /></font><font
id="yiv2072469051m_1911922675164783267yiv2305844011m_5682970348618810673yui_3_16_0_ym19_1_1467319472979_3360"size="3"
style="font-weight:bold;"><ahref="http://www.youtube.com/unusedhero/videos"
id="yiv2072469051m_1911922675164783267yui_3_16_0_1_1480447941789_22647"rel="nofollow" shape="rect"
target="_blank">www.youtube.com/unusedhero/videos</a><br clear="none" /></font><font
id="yiv2072469051m_1911922675164783267yiv2305844011m_5682970348618810673yui_3_16_0_1_1480442930679_8670"size="3"><span
id="yiv2072469051m_1911922675164783267yiv2305844011m_5682970348618810673yui_3_16_0_1_1480442930679_8669"
style="font-weight:bold;font-family:courier;">FolkAlley - All Folk - 24 Hours a day </span><span
id="yiv2072469051m_1911922675164783267yiv2305844011m_5682970348618810673yui_3_16_0_1_1480442930679_8673"
style="font-weight:bold;font-family:courier;"><brclear="none" /><a href="http://www.folkalley.com/" rel="nofollow"
shape="rect"target="_blank">www.folkalley.com</a><br clear="none" /><br clear="none"
/></span></font></span></div></div><div
class="yiv2072469051m_1911922675164783267yiv2305844011m_5682970348618810673qtdSeparateBR"
id="yiv2072469051m_1911922675164783267yiv2305844011m_5682970348618810673yui_3_16_0_1_1480442930679_8442"><br
clear="none"/><br clear="none" /></div><div
class="yiv2072469051m_1911922675164783267yiv2305844011m_5682970348618810673yahoo_quoted"
id="yiv2072469051m_1911922675164783267yiv2305844011m_5682970348618810673yui_3_16_0_1_1480442930679_8446"
style="display:block;"><div
id="yiv2072469051m_1911922675164783267yiv2305844011m_5682970348618810673yui_3_16_0_1_1480442930679_8445"
style="font-family:CourierNew, courier, monaco, monospace, sans-serif;font-size:16px;"><div
id="yiv2072469051m_1911922675164783267yiv2305844011m_5682970348618810673yui_3_16_0_1_1480442930679_8444"
style="font-family:HelveticaNeue,Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:16px;"><span
class="yiv2072469051"></span><div dir="ltr"
id="yiv2072469051m_1911922675164783267yiv2305844011m_5682970348618810673yui_3_16_0_1_1480442930679_8503"><font
face="Arial"id="yiv2072469051m_1911922675164783267yiv2305844011m_5682970348618810673yui_3_16_0_1_1480442930679_8674"
size="2"></font><hr size="1" /><b><span style="font-weight:bold;">From:</span></b> Malik Rumi <<a
href="mailto:malik.a.rumi@gmail.com"id="yiv2072469051m_1911922675164783267yui_3_16_0_1_1480447941789_22630"
rel="nofollow"shape="rect" target="_blank" ymailto="mailto:malik.a.rumi@gmail.com">malik.a.rumi@gmail.com</a>><br
clear="none"/><b><span style="font-weight:bold;">To:</span></b> pgAdmin Support <<a
href="mailto:pgadmin-support@postgresql.org"rel="nofollow" shape="rect" target="_blank"
ymailto="mailto:pgadmin-support@postgresql.org">pgadmin-support@postgresql.org</a>> <br clear="none" /><b><span
style="font-weight:bold;">Sent:</span></b>Tuesday, November 29, 2016 1:17 PM<br clear="none" /><b><span
style="font-weight:bold;">Subject:</span></b>[pgadmin-support] ROLLBACK syntax error in pgadmin4<br clear="none"
/></div><divid="yiv2072469051m_1911922675164783267yui_3_16_0_1_1480447941789_22718"><div
class="yiv2072469051m_1911922675164783267yiv2305844011h5"
id="yiv2072469051m_1911922675164783267yui_3_16_0_1_1480447941789_22717"><div
class="yiv2072469051m_1911922675164783267yiv2305844011m_5682970348618810673y_msg_container"
id="yiv2072469051m_1911922675164783267yiv2305844011m_5682970348618810673yui_3_16_0_1_1480442930679_8443"><br
clear="none"/><div id="yiv2072469051m_1911922675164783267yiv2305844011m_5682970348618810673yiv6295819857"><div
dir="ltr"id="yiv2072469051m_1911922675164783267yiv2305844011m_5682970348618810673yui_3_16_0_1_1480442930679_8447"><span
class="yiv2072469051"id="yui_3_16_0_ym19_1_1480456117764_25953">I am using PGAdmin4 with PG 9.4 on Ubuntu 16.04 64 bit.
Iwanted to do an update, but was unsure of the result, so I unselected autocommit and ran explain. It said only one row
wasaffected, which I didn’t understand, because it should have affected at least 2. Then I inferred that the ‘one row’
beingreferred to was the plan, not the rows in my data. </span><div
class="yiv2072469051m_1911922675164783267yiv2305844011m_5682970348618810673yiv6295819857gmail-western"
style="margin-bottom:0in;line-height:100%;"></div><div
class="yiv2072469051m_1911922675164783267yiv2305844011m_5682970348618810673yiv6295819857gmail-western"
id="yiv2072469051m_1911922675164783267yiv2305844011m_5682970348618810673yui_3_16_0_1_1480442930679_8448"
style="margin-bottom:0in;line-height:100%;">ThenI ran the update, again no autocommit, and it was not what I expected.
Sothen I added ROLLBACK to the end of the query, ran it again, and got this error:</div><div
class="yiv2072469051m_1911922675164783267yiv2305844011m_5682970348618810673yiv6295819857gmail-western"
id="yiv2072469051m_1911922675164783267yiv2305844011m_5682970348618810673yui_3_16_0_1_1480442930679_8449"
style="margin-bottom:0in;line-height:100%;margin-left:40px;">ERROR:syntax error at or near "ROLLBACK" LINE 1: ...de"
SETchildof_id = NULL WHERE codelevelsortseq=1 ROLLBACK;</div><div
class="yiv2072469051m_1911922675164783267yiv2305844011m_5682970348618810673yiv6295819857gmail-western"
id="yui_3_16_0_ym19_1_1480456117764_25955"style="margin-bottom:0in;line-height:100%;">I then did a new query, with just
ROLLBACK;as I see it explained with an example in the docs: <a
href="https://www.postgresql.org/docs/9.4/static/sql-rollback.html"id="yui_3_16_0_ym19_1_1480456117764_25984"
rel="nofollow"shape="rect" target="_blank">https://www.postgresql.org/ docs/9.4/static/sql-rollback. html</a></div><div
class="yiv2072469051m_1911922675164783267yiv2305844011m_5682970348618810673yiv6295819857gmail-western"
id="yiv2072469051m_1911922675164783267yiv2305844011m_5682970348618810673yui_3_16_0_1_1480442930679_8451"
style="margin-bottom:0in;line-height:100%;">Nevertheless,I got the same error:</div><div
class="yiv2072469051m_1911922675164783267yiv2305844011m_5682970348618810673yiv6295819857gmail-western"
id="yui_3_16_0_ym19_1_1480456117764_25956"style="margin-bottom:0in;line-height:100%;margin-left:40px;">ERROR: syntax
errorat or near "ROLLBACK" LINE 1: ...F, VERBOSE ON, COSTS ON, BUFFERS OFF, TIMING OFF) ROLLBACK;</div><br clear="none"
/>Notein this case ROLLBACK; is the only thing on Line 1. The error carat (^) is pointing at the R in both cases. No
otherqueries have been run in the interim. <div
class="yiv2072469051m_1911922675164783267yiv2305844011m_5682970348618810673yiv6295819857gmail-western"
id="yiv2072469051m_1911922675164783267yiv2305844011m_5682970348618810673yui_3_16_0_1_1480442930679_8455"
style="margin-bottom:0in;line-height:100%;">Tomy surprise, there are very few Google hits for this exact search:
</div><divclass="yiv2072469051m_1911922675164783267yiv2305844011m_5682970348618810673yiv6295819857gmail-western"
id="yui_3_16_0_ym19_1_1480456117764_25985"style="margin-bottom:0in;line-height:100%;margin-left:40px;">"syntax error at
ornear 'ROLLBACK'" About 30 results (0.34 seconds) </div><div
class="yiv2072469051m_1911922675164783267yiv2305844011m_5682970348618810673yiv6295819857gmail-western"
id="yui_3_16_0_ym19_1_1480456117764_25987"style="margin-bottom:0in;line-height:100%;">The first two hits are for a bug
reportfrom Nov. of 2006, which was fixed then and there. I don’t think this is the same bug, if it is a bug. </div><div
class="yiv2072469051m_1911922675164783267yiv2305844011m_5682970348618810673yiv6295819857gmail-western"
id="yiv2072469051m_1911922675164783267yiv2305844011m_5682970348618810673yui_3_16_0_1_1480442930679_8453"
style="margin-bottom:0in;line-height:100%;">Idid find DISCARD in the docs: <a
href="https://www.postgresql.org/docs/9.4/static/sql-discard.html"id="yui_3_16_0_ym19_1_1480456117764_26002"
rel="nofollow"shape="rect" target="_blank">https://www.postgresql.org/ docs/9.4/static/sql-discard. html</a> however, I
havenot run it because I wanted some clarity here and didn’t want to interfere with my ROLLBACK, if it would even have
thateffect.</div><span class="yiv2072469051"> </span><div
class="yiv2072469051m_1911922675164783267yiv2305844011m_5682970348618810673yiv6295819857gmail-western"
style="margin-bottom:0in;line-height:100%;">So,my questions:</div><div
class="yiv2072469051m_1911922675164783267yiv2305844011m_5682970348618810673yiv6295819857gmail-western"
id="yui_3_16_0_ym19_1_1480456117764_26004"style="margin-bottom:0in;line-height:100%;">1. How do I discard this update
andget my data back?</div><div
class="yiv2072469051m_1911922675164783267yiv2305844011m_5682970348618810673yiv6295819857gmail-western"
id="yiv2072469051m_1911922675164783267yui_3_16_0_1_1480447941789_22721"style="margin-bottom:0in;line-height:100%;">2.
Howdo I check to make sure it really isn’t committed without upsetting my ROLLBACK options? (Yes, I do have a backup I
cango to, but I would rather understand what is happening and fix it).</div><div
class="yiv2072469051m_1911922675164783267yiv2305844011m_5682970348618810673yiv6295819857gmail-western"
style="margin-bottom:0in;line-height:100%;">4.If it isn’t committed, and this is a bug, can I just close PGAdmin4
and/orPG and discard the changes that way?</div><div
class="yiv2072469051m_1911922675164783267yiv2305844011m_5682970348618810673yiv6295819857gmail-western"
id="yiv2072469051m_1911922675164783267yui_3_16_0_1_1480447941789_22722"style="margin-bottom:0in;line-height:100%;">5.
Isthis a new, different bug?</div><div
class="yiv2072469051m_1911922675164783267yiv2305844011m_5682970348618810673yiv6295819857gmail-western"
id="yiv2072469051m_1911922675164783267yui_3_16_0_1_1480447941789_22724"style="margin-bottom:0in;line-height:100%;">6.
Whatwas that 'one row effected' about?<br clear="none" /></div></div></div><br clear="none" /><br clear="none"
/></div></div></div></div></div></div></div></div></blockquote></div><brclear="none" /></div></div></div></div><br
clear="none"/><br clear="none" /></div></div></div></div></div></div></blockquote></div><br clear="none"
/></div></div></div></div><br/><br /></div></div></div></div></div>