← Back to branch summary

~ubuntu-branches/ubuntu/oneiric/postgresql-9.1/oneiric-security

« back to all changes in this revision

Viewing changes to doc/src/sgml/html/sql-release-savepoint.html

  • Committer: Bazaar Package Importer
  • Author(s): Martin Pitt
  • Date: 2011-05-11 10:41:53 UTC
  • Revision ID: james.westby@ubuntu.com-20110511104153-psbh2o58553fv1m0
Tags: upstream-9.1~beta1
Import upstream version 9.1~beta1

Show diffs side-by-side

added added

removed removed

Lines of Context:
doc/src/sgml/html/sql-release-savepoint.html
 
1
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
 
2
<HTML
 
3
><HEAD
 
4
><TITLE
 
5
>RELEASE SAVEPOINT</TITLE
 
6
><META
 
7
NAME="GENERATOR"
 
8
CONTENT="Modular DocBook HTML Stylesheet Version 1.79"><LINK
 
9
REV="MADE"
 
10
HREF="mailto:pgsql-docs@postgresql.org"><LINK
 
11
REL="HOME"
 
12
TITLE="PostgreSQL 9.1beta1 Documentation"
 
13
HREF="index.html"><LINK
 
14
REL="UP"
 
15
TITLE="SQL Commands"
 
16
HREF="sql-commands.html"><LINK
 
17
REL="PREVIOUS"
 
18
TITLE="REINDEX"
 
19
HREF="sql-reindex.html"><LINK
 
20
REL="NEXT"
 
21
TITLE="RESET"
 
22
HREF="sql-reset.html"><LINK
 
23
REL="STYLESHEET"
 
24
TYPE="text/css"
 
25
HREF="stylesheet.css"><META
 
26
HTTP-EQUIV="Content-Type"
 
27
CONTENT="text/html; charset=ISO-8859-1"><META
 
28
NAME="creation"
 
29
CONTENT="2011-04-27T21:20:33"></HEAD
 
30
><BODY
 
31
CLASS="REFENTRY"
 
32
><DIV
 
33
CLASS="NAVHEADER"
 
34
><TABLE
 
35
SUMMARY="Header navigation table"
 
36
WIDTH="100%"
 
37
BORDER="0"
 
38
CELLPADDING="0"
 
39
CELLSPACING="0"
 
40
><TR
 
41
><TH
 
42
COLSPAN="5"
 
43
ALIGN="center"
 
44
VALIGN="bottom"
 
45
><A
 
46
HREF="index.html"
 
47
>PostgreSQL 9.1beta1 Documentation</A
 
48
></TH
 
49
></TR
 
50
><TR
 
51
><TD
 
52
WIDTH="10%"
 
53
ALIGN="left"
 
54
VALIGN="top"
 
55
><A
 
56
TITLE="REINDEX"
 
57
HREF="sql-reindex.html"
 
58
ACCESSKEY="P"
 
59
>Prev</A
 
60
></TD
 
61
><TD
 
62
WIDTH="10%"
 
63
ALIGN="left"
 
64
VALIGN="top"
 
65
><A
 
66
TITLE="REINDEX"
 
67
HREF="sql-reindex.html"
 
68
>Fast Backward</A
 
69
></TD
 
70
><TD
 
71
WIDTH="60%"
 
72
ALIGN="center"
 
73
VALIGN="bottom"
 
74
></TD
 
75
><TD
 
76
WIDTH="10%"
 
77
ALIGN="right"
 
78
VALIGN="top"
 
79
><A
 
80
TITLE="RESET"
 
81
HREF="sql-reset.html"
 
82
>Fast Forward</A
 
83
></TD
 
84
><TD
 
85
WIDTH="10%"
 
86
ALIGN="right"
 
87
VALIGN="top"
 
88
><A
 
89
TITLE="RESET"
 
90
HREF="sql-reset.html"
 
91
ACCESSKEY="N"
 
92
>Next</A
 
93
></TD
 
94
></TR
 
95
></TABLE
 
96
><HR
 
97
ALIGN="LEFT"
 
98
WIDTH="100%"></DIV
 
99
><H1
 
100
><A
 
101
NAME="SQL-RELEASE-SAVEPOINT"
 
102
></A
 
103
>RELEASE SAVEPOINT</H1
 
104
><DIV
 
105
CLASS="REFNAMEDIV"
 
106
><A
 
107
NAME="AEN73489"
 
108
></A
 
109
><H2
 
110
>Name</H2
 
111
>RELEASE SAVEPOINT&nbsp;--&nbsp;destroy a previously defined savepoint</DIV
 
112
><DIV
 
113
CLASS="REFSYNOPSISDIV"
 
114
><A
 
115
NAME="AEN73497"
 
116
></A
 
117
><H2
 
118
>Synopsis</H2
 
119
><PRE
 
120
CLASS="SYNOPSIS"
 
121
>RELEASE [ SAVEPOINT ] <TT
 
122
CLASS="REPLACEABLE"
 
123
><I
 
124
>savepoint_name</I
 
125
></TT
 
126
></PRE
 
127
></DIV
 
128
><DIV
 
129
CLASS="REFSECT1"
 
130
><A
 
131
NAME="AEN73500"
 
132
></A
 
133
><H2
 
134
>Description</H2
 
135
><P
 
136
>   <TT
 
137
CLASS="COMMAND"
 
138
>RELEASE SAVEPOINT</TT
 
139
> destroys a savepoint previously defined
 
140
   in the current transaction.
 
141
  </P
 
142
><P
 
143
>   Destroying a savepoint makes it unavailable as a rollback point,
 
144
   but it has no other user visible behavior.  It does not undo the
 
145
   effects of commands executed after the savepoint was established.
 
146
   (To do that, see <A
 
147
HREF="sql-rollback-to.html"
 
148
>ROLLBACK TO SAVEPOINT</A
 
149
>.)
 
150
   Destroying a savepoint when
 
151
   it is no longer needed allows the system to reclaim some resources
 
152
   earlier than transaction end.
 
153
  </P
 
154
><P
 
155
>   <TT
 
156
CLASS="COMMAND"
 
157
>RELEASE SAVEPOINT</TT
 
158
> also destroys all savepoints that were
 
159
   established after the named savepoint was established.
 
160
  </P
 
161
></DIV
 
162
><DIV
 
163
CLASS="REFSECT1"
 
164
><A
 
165
NAME="AEN73508"
 
166
></A
 
167
><H2
 
168
>Parameters</H2
 
169
><P
 
170
></P
 
171
><DIV
 
172
CLASS="VARIABLELIST"
 
173
><DL
 
174
><DT
 
175
><TT
 
176
CLASS="REPLACEABLE"
 
177
><I
 
178
>savepoint_name</I
 
179
></TT
 
180
></DT
 
181
><DD
 
182
><P
 
183
>      The name of the savepoint to destroy.
 
184
     </P
 
185
></DD
 
186
></DL
 
187
></DIV
 
188
></DIV
 
189
><DIV
 
190
CLASS="REFSECT1"
 
191
><A
 
192
NAME="AEN73516"
 
193
></A
 
194
><H2
 
195
>Notes</H2
 
196
><P
 
197
>   Specifying a savepoint name that was not previously defined is an error.
 
198
  </P
 
199
><P
 
200
>   It is not possible to release a savepoint when the transaction is in
 
201
   an aborted state.
 
202
  </P
 
203
><P
 
204
>   If multiple savepoints have the same name, only the one that was most
 
205
   recently defined is released.
 
206
  </P
 
207
></DIV
 
208
><DIV
 
209
CLASS="REFSECT1"
 
210
><A
 
211
NAME="AEN73521"
 
212
></A
 
213
><H2
 
214
>Examples</H2
 
215
><P
 
216
>   To establish and later destroy a savepoint:
 
217
</P><PRE
 
218
CLASS="PROGRAMLISTING"
 
219
>BEGIN;
 
220
    INSERT INTO table1 VALUES (3);
 
221
    SAVEPOINT my_savepoint;
 
222
    INSERT INTO table1 VALUES (4);
 
223
    RELEASE SAVEPOINT my_savepoint;
 
224
COMMIT;</PRE
 
225
><P>
 
226
   The above transaction will insert both 3 and 4.
 
227
  </P
 
228
></DIV
 
229
><DIV
 
230
CLASS="REFSECT1"
 
231
><A
 
232
NAME="AEN73525"
 
233
></A
 
234
><H2
 
235
>Compatibility</H2
 
236
><P
 
237
>   This command conforms to the <ACRONYM
 
238
CLASS="ACRONYM"
 
239
>SQL</ACRONYM
 
240
> standard.  The standard
 
241
   specifies that the key word <TT
 
242
CLASS="LITERAL"
 
243
>SAVEPOINT</TT
 
244
> is
 
245
   mandatory, but <SPAN
 
246
CLASS="PRODUCTNAME"
 
247
>PostgreSQL</SPAN
 
248
> allows it to
 
249
   be omitted.
 
250
  </P
 
251
></DIV
 
252
><DIV
 
253
CLASS="REFSECT1"
 
254
><A
 
255
NAME="AEN73531"
 
256
></A
 
257
><H2
 
258
>See Also</H2
 
259
><A
 
260
HREF="sql-begin.html"
 
261
>BEGIN</A
 
262
>, <A
 
263
HREF="sql-commit.html"
 
264
>COMMIT</A
 
265
>, <A
 
266
HREF="sql-rollback.html"
 
267
>ROLLBACK</A
 
268
>, <A
 
269
HREF="sql-rollback-to.html"
 
270
>ROLLBACK TO SAVEPOINT</A
 
271
>, <A
 
272
HREF="sql-savepoint.html"
 
273
>SAVEPOINT</A
 
274
></DIV
 
275
><DIV
 
276
CLASS="NAVFOOTER"
 
277
><HR
 
278
ALIGN="LEFT"
 
279
WIDTH="100%"><TABLE
 
280
SUMMARY="Footer navigation table"
 
281
WIDTH="100%"
 
282
BORDER="0"
 
283
CELLPADDING="0"
 
284
CELLSPACING="0"
 
285
><TR
 
286
><TD
 
287
WIDTH="33%"
 
288
ALIGN="left"
 
289
VALIGN="top"
 
290
><A
 
291
HREF="sql-reindex.html"
 
292
ACCESSKEY="P"
 
293
>Prev</A
 
294
></TD
 
295
><TD
 
296
WIDTH="34%"
 
297
ALIGN="center"
 
298
VALIGN="top"
 
299
><A
 
300
HREF="index.html"
 
301
ACCESSKEY="H"
 
302
>Home</A
 
303
></TD
 
304
><TD
 
305
WIDTH="33%"
 
306
ALIGN="right"
 
307
VALIGN="top"
 
308
><A
 
309
HREF="sql-reset.html"
 
310
ACCESSKEY="N"
 
311
>Next</A
 
312
></TD
 
313
></TR
 
314
><TR
 
315
><TD
 
316
WIDTH="33%"
 
317
ALIGN="left"
 
318
VALIGN="top"
 
319
>REINDEX</TD
 
320
><TD
 
321
WIDTH="34%"
 
322
ALIGN="center"
 
323
VALIGN="top"
 
324
><A
 
325
HREF="sql-commands.html"
 
326
ACCESSKEY="U"
 
327
>Up</A
 
328
></TD
 
329
><TD
 
330
WIDTH="33%"
 
331
ALIGN="right"
 
332
VALIGN="top"
 
333
>RESET</TD
 
334
></TR
 
335
></TABLE
 
336
></DIV
 
337
></BODY
 
338
></HTML
 
339
>
 
 
b'\\ No newline at end of file'