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

Commitb965f26

Browse files
committed
Do not dump identity sequences with excluded parent table
This commit prevents a crash of pg_dump caused by the exclusion of atable which has identity columns, as the table would be correctlyexcluded but not its identity sequence. In order to fix that, identitysequences are excluded if the parent table is defined as such. Knowingabout such sequences has no meaning without their parent table anyway.Reported-by: Andy AbelistoAuthor: David RowleyReviewed-by: Peter Eisentraut, Michael PaquierDiscussion:https://postgr.es/m/153479393218.1316.8472285660264976457@wrigleys.postgresql.orgBackpatch-through: 10
1 parent98abc73 commitb965f26

File tree

1 file changed

+14
-2
lines changed

1 file changed

+14
-2
lines changed

‎src/bin/pg_dump/pg_dump.c

Lines changed: 14 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -6636,8 +6636,20 @@ getOwnedSeqs(Archive *fout, TableInfo tblinfo[], int numTables)
66366636
seqinfo->owning_tab, seqinfo->dobj.catId.oid);
66376637

66386638
/*
6639-
* We need to dump the components that are being dumped for the table
6640-
* and any components which the sequence is explicitly marked with.
6639+
* Only dump identity sequences if we're going to dump the table that
6640+
* it belongs to.
6641+
*/
6642+
if (owning_tab->dobj.dump == DUMP_COMPONENT_NONE &&
6643+
seqinfo->is_identity_sequence)
6644+
{
6645+
seqinfo->dobj.dump = DUMP_COMPONENT_NONE;
6646+
continue;
6647+
}
6648+
6649+
/*
6650+
* Otherwise we need to dump the components that are being dumped for
6651+
* the table and any components which the sequence is explicitly
6652+
* marked with.
66416653
*
66426654
* We can't simply use the set of components which are being dumped
66436655
* for the table as the table might be in an extension (and only the

0 commit comments

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