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

Commitcd3e274

Browse files
committed
Fix potential catalog corruption with temporary identity columns
If a temporary table with an identity column and ON COMMIT DROP iscreated in a single-statement transaction (not useful, but allowed),it would leave the catalog corrupted. We need to add aCommandCounterIncrement() so that PreCommit_on_commit_actions() seesthe created dependency between table and sequence and can clean itup.The analogous and more useful case of doing this in a transactionblock already runs some CommandCounterIncrement() before it gets tothe on-commit cleanup, so it wasn't a problem in practical use.Several locations for placing the new CommandCounterIncrement() callwere discussed. This patch places it at the end ofstandard_ProcessUtility(). That would also help if other commandswere to create catalog entries that some on-commit action would liketo see.Bug: #15631Reported-by: Serge Latyntsev <dnsl48@gmail.com>Author: Peter Eisentraut <peter.eisentraut@2ndquadrant.com>Reviewed-by: Michael Paquier <michael@paquier.xyz>
1 parentc3f67ed commitcd3e274

File tree

1 file changed

+7
-0
lines changed

1 file changed

+7
-0
lines changed

‎src/backend/tcop/utility.c

Lines changed: 7 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -931,6 +931,13 @@ standard_ProcessUtility(PlannedStmt *pstmt,
931931
}
932932

933933
free_parsestate(pstate);
934+
935+
/*
936+
* Make effects of commands visible, for instance so that
937+
* PreCommit_on_commit_actions() can see them (see for example bug
938+
* #15631).
939+
*/
940+
CommandCounterIncrement();
934941
}
935942

936943
/*

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp