Content-Length: 274739 | pFad | http://github.com/postgrespro/postgres/commit/5a39114fe7d19280f6477ce1eb0d88beafda13a4

4B In pg_dump, dump SEQUENCE SET items in the data not pre-data section. · postgrespro/postgres@5a39114 · GitHub
Skip to content

Commit 5a39114

Browse files
tglsfdctglsfdc
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 dumpable object, so that it can be dumped within the data section of the archive rather than in pre-data. This fixes an undesirable inconsistency between the meanings of "--data-only" and "--section=data", and also fixes dumping of sequences that are marked as extension configuration tables, as per a report from Marko Kreen back in July. The main cost is that we do one more SQL query per sequence, but that's probably not very meaningful in most databases. Back-patch to 9.1, since it has the extension configuration issue even though not the --section switch.
1 parent bf01e34 commit 5a39114

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 items consist of definitions of indexes, triggers, rules
742+
The data section contains actual table data, large-object
743+
contents, and sequence values.
744+
Post-data items include definitions of indexes, triggers, rules,
745745
and constraints other than validated check constraints.
746-
Pre-data items consist of all other data definition items.
746+
Pre-data items include all other data definition items.
747747
</para>
748748
</listitem>
749749
</varlistentry>

0 commit comments

Comments
 (0)








ApplySandwichStrip

pFad - (p)hone/(F)rame/(a)nonymizer/(d)eclutterfier!      Saves Data!


--- a PPN by Garber Painting Akron. With Image Size Reduction included!

Fetched URL: http://github.com/postgrespro/postgres/commit/5a39114fe7d19280f6477ce1eb0d88beafda13a4

Alternative Proxies:

Alternative Proxy

pFad Proxy

pFad v3 Proxy

pFad v4 Proxy