Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commite9cda08

Browse files
committed
Brief note about sequence cache not being cleared in other backends.
Actually clear the cache in the backend making the alteration. Thisfollows in the footsteps of setval().Rod Taylor
1 parentb4cea00 commite9cda08

File tree

4 files changed

+55
-5
lines changed

4 files changed

+55
-5
lines changed

‎doc/src/sgml/keywords.sgml‎

Lines changed: 19 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -1,4 +1,4 @@
1-
<!-- $Header: /cvsroot/pgsql/doc/src/sgml/keywords.sgml,v 2.8 2002/11/11 20:14:03 petere Exp $ -->
1+
<!-- $Header: /cvsroot/pgsql/doc/src/sgml/keywords.sgml,v 2.9 2003/06/12 07:49:43 momjian Exp $ -->
22

33
<appendix id="sql-keywords-appendix">
44
<title><acronym>SQL</acronym> Key Words</title>
@@ -872,6 +872,12 @@
872872
<entry>reserved</entry>
873873
<entry>reserved</entry>
874874
</row>
875+
<row>
876+
<entry><token>DEFAULTS</token></entry>
877+
<entry>non-reserved</entry>
878+
<entry></entry>
879+
<entry></entry>
880+
</row>
875881
<row>
876882
<entry><token>DEFERRABLE</token></entry>
877883
<entry>reserved</entry>
@@ -1100,6 +1106,12 @@
11001106
<entry>reserved</entry>
11011107
<entry>reserved</entry>
11021108
</row>
1109+
<row>
1110+
<entry><token>EXCLUDING</token></entry>
1111+
<entry>non-reserved</entry>
1112+
<entry></entry>
1113+
<entry></entry>
1114+
</row>
11031115
<row>
11041116
<entry><token>EXCLUSIVE</token></entry>
11051117
<entry>non-reserved</entry>
@@ -1394,6 +1406,12 @@
13941406
<entry>reserved</entry>
13951407
<entry>reserved</entry>
13961408
</row>
1409+
<row>
1410+
<entry><token>INCLUDING</token></entry>
1411+
<entry>non-reserved</entry>
1412+
<entry></entry>
1413+
<entry></entry>
1414+
</row>
13971415
<row>
13981416
<entry><token>INCREMENT</token></entry>
13991417
<entry>non-reserved</entry>

‎doc/src/sgml/ref/alter_sequence.sgml‎

Lines changed: 7 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -1,5 +1,5 @@
11
<!--
2-
$Header: /cvsroot/pgsql/doc/src/sgml/ref/alter_sequence.sgml,v 1.1 2003/03/20 07:02:07 momjian Exp $
2+
$Header: /cvsroot/pgsql/doc/src/sgml/ref/alter_sequence.sgml,v 1.2 2003/06/12 07:49:43 momjian Exp $
33
PostgreSQL documentation
44
-->
55

@@ -236,6 +236,12 @@ ALTER SEQUENCE serial RESTART WITH 105;
236236
later aborts. This means that aborted transactions may leave unused "holes" in
237237
the sequence of assigned values. setval operations are never rolled back, either.
238238
</para>
239+
<para>
240+
<command>ALTER SEQUENCE</command> will not immediately affect backends, other than the
241+
current one, which have cached sequence values. They must use up all cached values
242+
prior to noticing the changed sequence parameters. The current backend will be
243+
immediatly affected.
244+
</para>
239245
</refsect1>
240246

241247

‎doc/src/sgml/ref/create_table.sgml‎

Lines changed: 23 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -1,5 +1,5 @@
11
<!--
2-
$Header: /cvsroot/pgsql/doc/src/sgml/ref/create_table.sgml,v 1.68 2003/05/04 00:03:55 tgl Exp $
2+
$Header: /cvsroot/pgsql/doc/src/sgml/ref/create_table.sgml,v 1.69 2003/06/12 07:49:43 momjian Exp $
33
PostgreSQL documentation
44
-->
55

@@ -18,7 +18,8 @@ PostgreSQL documentation
1818
<synopsis>
1919
CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } ] TABLE <replaceable class="PARAMETER">table_name</replaceable> (
2020
{ <replaceable class="PARAMETER">column_name</replaceable> <replaceable class="PARAMETER">data_type</replaceable> [ DEFAULT <replaceable>default_expr</> ] [ <replaceable class="PARAMETER">column_constraint</replaceable> [, ... ] ]
21-
| <replaceable>table_constraint</replaceable> } [, ... ]
21+
| <replaceable>table_constraint</replaceable>
22+
| LIKE <replaceable>parent_table</replaceable> [ { INCLUDING | EXCLUDING } DEFAULTS ] } [, ... ]
2223
)
2324
[ INHERITS ( <replaceable>parent_table</replaceable> [, ... ] ) ]
2425
[ WITH OIDS | WITHOUT OIDS ]
@@ -172,6 +173,26 @@ and <replaceable class="PARAMETER">table_constraint</replaceable> is:
172173
</listitem>
173174
</varlistentry>
174175

176+
<varlistentry>
177+
<term><literal>LIKE <replaceable>parent_table</replaceable> [ { INCLUDING | EXCLUDING } DEFAULTS ]</literal></term>
178+
<listitem>
179+
<para>
180+
The <literal>LIKE</literal> clause specifies a table from which
181+
the new table automatically inherits all column names, their datatypes, and
182+
<literal>NOT NULL</literal> constraints.
183+
</para>
184+
<para>
185+
Unlike <literal>INHERITS</literal>, the new table and inherited table
186+
are complete decoupled after creation has been completed. Data inserted
187+
into the new table will not be reflected into the parent table.
188+
</para>
189+
<para>
190+
Default expressions for the inherited column definitions will only be included if
191+
<literal>INCLUDING DEFAULTS</literal> is specified. The default is to exclude
192+
default expressions.
193+
</listitem>
194+
</varlistentry>
195+
175196
<varlistentry>
176197
<term><literal>INHERITS ( <replaceable>parent_table</replaceable> [, ... ] )</literal></term>
177198
<listitem>

‎src/backend/commands/sequence.c‎

Lines changed: 6 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -8,7 +8,7 @@
88
*
99
*
1010
* IDENTIFICATION
11-
* $Header: /cvsroot/pgsql/src/backend/commands/sequence.c,v 1.95 2003/03/21 03:55:21 momjian Exp $
11+
* $Header: /cvsroot/pgsql/src/backend/commands/sequence.c,v 1.96 2003/06/12 07:49:43 momjian Exp $
1212
*
1313
*-------------------------------------------------------------------------
1414
*/
@@ -345,6 +345,11 @@ AlterSequence(AlterSeqStmt *stmt)
345345
seq->log_cnt=1;
346346
}
347347

348+
/* save info in local cache */
349+
elm->last=new.last_value;/* last returned number */
350+
elm->cached=new.last_value;/* last cached number (forget cached
351+
* values) */
352+
348353
START_CRIT_SECTION();
349354

350355
/* XLOG stuff */

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp