http://sqle.ru/index.php?action=history&feed=atom&title=PostgreSQL%2FTransaction%2FAbort 2026-05-25T18:32:01Z История изменений этой страницы в вики MediaWiki 1.30.0 http://sqle.ru/index.php?title=PostgreSQL/Transaction/Abort&diff=4848&oldid=prev 2010-05-26T13:45:56Z

<p></p> <table class="diff diff-contentalign-left" data-mw="interface"> <tr style="vertical-align: top;" lang="ru"> <td colspan="1" style="background-color: white; color:black; text-align: center;">← Предыдущая</td> <td colspan="1" style="background-color: white; color:black; text-align: center;">Версия 13:45, 26 мая 2010</td> </tr><tr><td colspan="2" style="text-align: center;" lang="ru"><div class="mw-diff-empty">(нет различий)</div> </td></tr></table>

http://sqle.ru/index.php?title=PostgreSQL/Transaction/Abort&diff=4849&oldid=prev 2010-05-26T10:14:21Z

<p>1 версия</p> <p><b>Новая страница</b></p><div>==Use ABORT to undo an accidental DELETE command==<br /> <br /> <br /> <br /> <br /> &lt;!-- start source code --&gt;<br /> <br /> &lt;source lang=&quot;sql&quot;&gt;<br /> <br /> postgres=#<br /> postgres=#<br /> postgres=# CREATE TABLE &quot;books&quot; (<br /> postgres(# &quot;id&quot; integer NOT NULL,<br /> postgres(# &quot;title&quot; text NOT NULL,<br /> postgres(# &quot;author_id&quot; integer,<br /> postgres(# &quot;subject_id&quot; integer,<br /> postgres(# Constraint &quot;books_id_pkey&quot; Primary Key (&quot;id&quot;)<br /> postgres(# );<br /> NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index &quot;books_id_pkey&quot; for table &quot;books&quot;<br /> CREATE TABLE<br /> postgres=#<br /> postgres=#<br /> postgres=# insert into books values (7808, &quot;Java&quot;, 4156, 9);<br /> INSERT 0 1<br /> postgres=# insert into books values (4513, &quot;Javascript&quot;, 1866, 15);<br /> INSERT 0 1<br /> postgres=# insert into books values (4267, &quot;C#&quot;, 2001, 15);<br /> INSERT 0 1<br /> postgres=# insert into books values (1608, &quot;Oracle&quot;, 1809, 2);<br /> INSERT 0 1<br /> postgres=# insert into books values (1590, &quot;Sql Server&quot;, 1809, 2);<br /> INSERT 0 1<br /> postgres=# insert into books values (25908, &quot;Postgre SQL&quot;, 15990, 2);<br /> INSERT 0 1<br /> postgres=# insert into books values (1501, &quot;Python&quot;, 2031, 2);<br /> INSERT 0 1<br /> postgres=# insert into books values (190, &quot;Java by API&quot;, 16, 6);<br /> INSERT 0 1<br /> postgres=# insert into books values (1234, &quot;2D&quot;, 25041, 3);<br /> INSERT 0 1<br /> postgres=# insert into books values (2038, &quot;C&quot;, 1644, 0);<br /> INSERT 0 1<br /> postgres=# insert into books values (156, &quot;C++&quot;, 115, 9);<br /> INSERT 0 1<br /> postgres=# insert into books values (41473, &quot;Programming Python&quot;, 7805, 4);<br /> INSERT 0 1<br /> postgres=# insert into books values (41477, &quot;Learning Python&quot;, 7805, 4);<br /> INSERT 0 1<br /> postgres=# insert into books values (41478, &quot;Perl Cookbook&quot;, 7806, 4);<br /> INSERT 0 1<br /> postgres=# insert into books values (41472, &quot;Practical PostgreSQL&quot;, 1212, 4);<br /> INSERT 0 1<br /> postgres=#<br /> postgres=# select * from books;<br /> id | title | author_id | subject_id<br /> -------+----------------------+-----------+------------<br /> 7808 | Java | 4156 | 9<br /> 4513 | Javascript | 1866 | 15<br /> 4267 | C# | 2001 | 15<br /> 1608 | Oracle | 1809 | 2<br /> 1590 | Sql Server | 1809 | 2<br /> 25908 | Postgre SQL | 15990 | 2<br /> 1501 | Python | 2031 | 2<br /> 190 | Java by API | 16 | 6<br /> 1234 | 2D | 25041 | 3<br /> 2038 | C | 1644 | 0<br /> 156 | C++ | 115 | 9<br /> 41473 | Programming Python | 7805 | 4<br /> 41477 | Learning Python | 7805 | 4<br /> 41478 | Perl Cookbook | 7806 | 4<br /> 41472 | Practical PostgreSQL | 1212 | 4<br /> (15 rows)<br /> postgres=#<br /> postgres=#<br /> postgres=# -- Use ABORT to undo an accidental DELETE command:<br /> postgres=#<br /> postgres=# BEGIN WORK;<br /> BEGIN<br /> postgres=# DELETE FROM books;<br /> DELETE 15<br /> postgres=# ABORT WORK;<br /> ROLLBACK<br /> postgres=#<br /> postgres=# select * from books;<br /> id | title | author_id | subject_id<br /> -------+----------------------+-----------+------------<br /> 7808 | Java | 4156 | 9<br /> 4513 | Javascript | 1866 | 15<br /> 4267 | C# | 2001 | 15<br /> 1608 | Oracle | 1809 | 2<br /> 1590 | Sql Server | 1809 | 2<br /> 25908 | Postgre SQL | 15990 | 2<br /> 1501 | Python | 2031 | 2<br /> 190 | Java by API | 16 | 6<br /> 1234 | 2D | 25041 | 3<br /> 2038 | C | 1644 | 0<br /> 156 | C++ | 115 | 9<br /> 41473 | Programming Python | 7805 | 4<br /> 41477 | Learning Python | 7805 | 4<br /> 41478 | Perl Cookbook | 7806 | 4<br /> 41472 | Practical PostgreSQL | 1212 | 4<br /> (15 rows)<br /> postgres=#<br /> postgres=# drop table books;<br /> DROP TABLE<br /> postgres=#<br /> postgres=#<br /> postgres=#<br /> <br /> &lt;/source&gt;</div>

Admin