summaryrefslogtreecommitdiffstats
path: root/src/backend/parser/parse_utilcmd.c
diff options
context:
space:
mode:
authorDaniel Baumann <daniel.baumann@progress-linux.org>2024-05-21 05:05:19 +0000
committerDaniel Baumann <daniel.baumann@progress-linux.org>2024-05-21 05:05:19 +0000
commitdd6c2fee6e501c9b51c8cce120b4ddc61b9a0b7e (patch)
tree925e323030fb13e98751efea8913af30f3ac5dcd /src/backend/parser/parse_utilcmd.c
parentAdding upstream version 15.6. (diff)
downloadpostgresql-15-dd6c2fee6e501c9b51c8cce120b4ddc61b9a0b7e.tar.xz
postgresql-15-dd6c2fee6e501c9b51c8cce120b4ddc61b9a0b7e.zip
Adding upstream version 15.7.upstream/15.7upstream
Signed-off-by: Daniel Baumann <daniel.baumann@progress-linux.org>
Diffstat (limited to 'src/backend/parser/parse_utilcmd.c')
-rw-r--r--src/backend/parser/parse_utilcmd.c11
1 files changed, 10 insertions, 1 deletions
diff --git a/src/backend/parser/parse_utilcmd.c b/src/backend/parser/parse_utilcmd.c
index b8dda03..5a06136 100644
--- a/src/backend/parser/parse_utilcmd.c
+++ b/src/backend/parser/parse_utilcmd.c
@@ -456,7 +456,16 @@ generateSerialExtraStmts(CreateStmtContext *cxt, ColumnDef *column,
seqstmt = makeNode(CreateSeqStmt);
seqstmt->for_identity = for_identity;
seqstmt->sequence = makeRangeVar(snamespace, sname, -1);
- seqstmt->sequence->relpersistence = cxt->relation->relpersistence;
+
+ /*
+ * Copy the persistence of the table. For CREATE TABLE, we get the
+ * persistence from cxt->relation, which comes from the CreateStmt in
+ * progress. For ALTER TABLE, the parser won't set
+ * cxt->relation->relpersistence, but we have cxt->rel as the existing
+ * table, so we copy the persistence from there.
+ */
+ seqstmt->sequence->relpersistence = cxt->rel ? cxt->rel->rd_rel->relpersistence : cxt->relation->relpersistence;
+
seqstmt->options = seqoptions;
/*