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

Commit5a39114

Browse files
committed
In pg_dump, dump SEQUENCE SET items in the data not pre-data section.
Represent a sequence's current value as a separate TableDataInfo dumpableobject, so that it can be dumped within the data section of the archiverather than in pre-data. This fixes an undesirable inconsistency betweenthe meanings of "--data-only" and "--section=data", and also fixes dumpingof sequences that are marked as extension configuration tables, as per areport from Marko Kreen back in July. The main cost is that we do one moreSQL query per sequence, but that's probably not very meaningful in mostdatabases.Back-patch to 9.1, since it has the extension configuration issue eventhough not the --section switch.
1 parentbf01e34 commit5a39114

File tree

2 files changed

+165
-152
lines changed

2 files changed

+165
-152
lines changed

‎doc/src/sgml/ref/pg_dump.sgml

Lines changed: 4 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -739,11 +739,11 @@ PostgreSQL documentation
739739
sections. The default is to dump all sections.
740740
</para>
741741
<para>
742-
The data section contains actual table data as well as large-object
743-
definitions.
744-
Post-data itemsconsist ofdefinitions of indexes, triggers, rules
742+
The data section contains actual table data, large-object
743+
contents, and sequence values.
744+
Post-data itemsincludedefinitions of indexes, triggers, rules,
745745
and constraints other than validated check constraints.
746-
Pre-data itemsconsist of all other data definition items.
746+
Pre-data itemsinclude all other data definition items.
747747
</para>
748748
</listitem>
749749
</varlistentry>

0 commit comments

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