postgres
diff --git a/‎src/backend/commands/sequence.c
Copy file name to clipboardExpand all lines: src/backend/commands/sequence.c
+7Lines changed: 7 additions & 0 deletions b/‎src/backend/commands/sequence.c
Copy file name to clipboardExpand all lines: src/backend/commands/sequence.c
+7Lines changed: 7 additions & 0 deletions
@@ -545,6 +545,13 @@ SequenceChangePersistence(Oid relid, char newrelpersistence)
 	Buffer		buf;
 	HeapTupleData seqdatatuple;
 
+	/*
+	 * ALTER SEQUENCE acquires this lock earlier.  If we're processing an
+	 * owned sequence for ALTER TABLE, lock now.  Without the lock, we'd
+	 * discard increments from nextval() calls (in other sessions) between
+	 * this function's buffer unlock and this transaction's commit.
+	 */
+	LockRelationOid(relid, AccessExclusiveLock);
 	init_sequence(relid, &elm, &seqrel);
 
 	/* check the comment above nextval_internal()'s equivalent call. */