|
14 | 14 | alink="#0000ff">
|
15 | 15 | <H1>Frequently Asked Questions (FAQ) for PostgreSQL</H1>
|
16 | 16 |
|
17 |
| -<P>Last updated: Tue Feb 12 12:14:52 EST 2002</P> |
| 17 | +<P>Last updated: Tue Feb 12 12:18:09 EST 2002</P> |
18 | 18 |
|
19 | 19 | <P>Current maintainer: Bruce Momjian (<Ahref=
|
20 | 20 | "mailto:pgman@candle.pha.pa.us">pgman@candle.pha.pa.us</A>)<BR>
|
@@ -120,7 +120,7 @@ <H2 align="center">Operational Questions</H2>
|
120 | 120 | <Ahref="#4.15.3">4.15.3</A>) Don't<I>currval()</I> and
|
121 | 121 | <I>nextval()</I> lead to a race condition with other users?<BR>
|
122 | 122 | <Ahref="#4.15.4">4.15.4</A>) Why aren't my sequence numbers reused
|
123 |
| - on transaction abort? Why are there gaps in thenumbers of my |
| 123 | + on transaction abort? Why are there gaps in thenumbering of my |
124 | 124 | sequence/SERIAL column?<BR>
|
125 | 125 | <Ahref="#4.16">4.16</A>) What is an<SMALL>OID</SMALL>? What is a
|
126 | 126 | <SMALL>TID</SMALL>?<BR>
|
@@ -1096,13 +1096,12 @@ <H4><A name="4.15.3">4.15.3</A>) Don't <I>currval()</I> and
|
1096 | 1096 | backend, not by all users.</P>
|
1097 | 1097 |
|
1098 | 1098 | <H4><Aname="4.15.4">4.15.4</A>) Why aren't my sequence numbers reused
|
1099 |
| - on transaction abort? Why are there gaps in thenumbers of my |
| 1099 | + on transaction abort? Why are there gaps in thenumbering of my |
1100 | 1100 | sequence/SERIAL column?</H4>
|
1101 | 1101 |
|
1102 | 1102 | <P>To improve concurrency, sequence values are given out to running
|
1103 |
| - transactions as needed and are now<i>locked</i> until the |
1104 |
| - transaction completes. This causes gaps in numbering from aborted |
1105 |
| - transactions. |
| 1103 | + transactions as needed and are not locked until the transaction |
| 1104 | + completes. This causes gaps in numbering from aborted transactions. |
1106 | 1105 |
|
1107 | 1106 | <H4><Aname="4.16">4.16</A>) What is an<SMALL>OID</SMALL>? What is
|
1108 | 1107 | a<SMALL>TID</SMALL>?</H4>
|
|