Horton

Re: Rollback table data.

Moreno Andreo <moreno.andreo@evolu-s.it>

View thread
From: Moreno Andreo <moreno.andreo@evolu-s.it>
To: pgsql-performance@postgresql.org
Date: 2017-06-07T12:42:44Z
Lists: pgsql-performance

Attachments

<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html;
      charset=windows-1252">
  </head>
  <body text="#000000" bgcolor="#FFFFFF">
    <div class="moz-cite-prefix"><br>
      Il 07/06/2017 13:33, Dinesh Chandra 12108 ha scritto:<br>
    </div>
    <blockquote type="cite"
      cite="mid:ff86727641ec47d18d11d41e7d89f0e4@cyient.com">
      <meta http-equiv="Content-Type" content="text/html;
        charset=windows-1252">
      <meta name="Generator" content="Microsoft Word 15 (filtered
        medium)">
      <style><!--
/* Font Definitions */
@font-face
	{font-family:"Cambria Math";
	panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
	{font-family:Calibri;
	panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
	{font-family:Effra;
	panose-1:2 11 6 3 2 2 3 2 2 4;}
@font-face
	{font-family:Verdana;
	panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
	{margin:0in;
	margin-bottom:.0001pt;
	font-size:11.0pt;
	font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
	{mso-style-priority:99;
	color:#0563C1;
	text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
	{mso-style-priority:99;
	color:#954F72;
	text-decoration:underline;}
span.EmailStyle17
	{mso-style-type:personal-compose;
	font-family:"Calibri",sans-serif;
	color:#1F4E79;
	font-weight:normal;
	font-style:normal;
	text-decoration:none none;}
.MsoChpDefault
	{mso-style-type:export-only;
	font-family:"Calibri",sans-serif;}
@page WordSection1
	{size:8.5in 11.0in;
	margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
	{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
      <div class="WordSection1">
        <p class="MsoNormal"><span style="color:#1F4E79">Dear Expert,<o:p></o:p></span></p>
        <p class="MsoNormal"><span style="color:#1F4E79"><o:p> </o:p></span></p>
        <p class="MsoNormal"><span style="color:#1F4E79">Is there any
            way to rollback table data in PostgreSQL?</span></p>
      </div>
    </blockquote>
    Not knowing anything else about your what you want to do and what
    context you're in, I can only say that AFAIK, once you COMMITted a
    transaction, no rollback is possible.<br>
    <br>
    A very quick google search gave me this:<br>
<a class="moz-txt-link-freetext" href="https://stackoverflow.com/questions/12472318/can-i-rollback-a-transaction-ive-already-committed-data-loss">https://stackoverflow.com/questions/12472318/can-i-rollback-a-transaction-ive-already-committed-data-loss</a><br>
    <br>
    There's a long, detailed post from Craig Ringer that gives you some
    advise on how to proceed (given that a committed transaction cannot
    be ROLLBACKed)<br>
    <br>
    Take a look, I hope it's applicable to your scenario.<br>
    <br>
    HTH<br>
    Moreno.-<br>
  </body>
</html>