1
1
<!--
2
- $Header: /cvsroot/pgsql/doc/src/sgml/ref/create_sequence.sgml,v 1.11 1999/07/22 15:09:08 thomas Exp $
2
+ $Header: /cvsroot/pgsql/doc/src/sgml/ref/create_sequence.sgml,v 1.12 2000/05/08 16:19:56 thomas Exp $
3
3
Postgres documentation
4
4
-->
5
5
@@ -210,7 +210,7 @@ ERROR: DefineSequence: MINVALUE (<replaceable class="parameter">min</replaceabl
210
210
</title>
211
211
<para>
212
212
<command>CREATE SEQUENCE</command> will enter a new sequence number generator
213
- into the current data base. This involves creating andinitialising a
213
+ into the current data base. This involves creating andinitializing a
214
214
new single-row
215
215
table with the name <replaceable class="parameter">seqname</replaceable>.
216
216
The generator will be "owned" by the user issuing the command.
@@ -238,20 +238,19 @@ ERROR: DefineSequence: MINVALUE (<replaceable class="parameter">min</replaceabl
238
238
Use a query like
239
239
240
240
<programlisting>
241
- SELECT * FROMsequence_name ;
241
+ SELECT * FROM<replaceable>seqname</replaceable> ;
242
242
</programlisting>
243
243
244
244
to get the parameters of a sequence.
245
245
246
- Aside from fetching the original
247
- parameters, you can use
246
+ As an alternative to fetching the
247
+ parameters from the original definition as above , you can use
248
248
249
249
<programlisting>
250
- SELECT last_value FROMsequence_name ;
250
+ SELECT last_value FROM<replaceable>seqname</replaceable> ;
251
251
</programlisting>
252
252
253
253
to obtain the last value allocated by any backend.
254
- parameters, you can use
255
254
</para>
256
255
257
256
<para>
@@ -263,7 +262,7 @@ SELECT last_value FROM sequence_name;
263
262
<para>
264
263
Unexpected results may be obtained if a cache setting greater than one
265
264
is used for a sequence object that will be used concurrently by multiple
266
- backends. Each backend will allocate" cache" successive sequence values
265
+ backends. Each backend will allocateand cache successive sequence values
267
266
during one access to the sequence object and increase the sequence
268
267
object's last_value accordingly. Then, the next cache-1 uses of nextval
269
268
within that backend simply return the preallocated values without touching
@@ -291,7 +290,7 @@ SELECT last_value FROM sequence_name;
291
290
Notes
292
291
</title>
293
292
<para>
294
- Refer to the <command>DROP SEQUENCE</command> statement to remove a sequence.
293
+ Use <command>DROP SEQUENCE</command> to remove a sequence.
295
294
</para>
296
295
<para>
297
296
Each backend uses its own cache to store allocated numbers.