Horton

Fix assorted bugs related to identity column in partitioned tables

Peter Eisentraut <peter@eisentraut.org>

View on postgr.es
Commit: 509199587df73f06eda898ae13284292f4ae573a
Author: Peter Eisentraut <peter@eisentraut.org>
Date: 2024-05-07T20:50:00Z
Releases: 17.0 
Fix assorted bugs related to identity column in partitioned tables

When changing the data type of a column of a partitioned table, craft
the ALTER SEQUENCE command only once.  Partitions do not have identity
sequences of their own and thus do not need a ALTER SEQUENCE command
for each partition.

Fix getIdentitySequence() to fetch the identity sequence associated
with the top-level partitioned table when a Relation of a partition is
passed to it.  While doing so, translate the attribute number of the
partition into the attribute number of the partitioned table.

Author: Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Reported-by: Alexander Lakhin <exclusion@gmail.com>
Reviewed-by: Dmitry Dolgov <9erthalion6@gmail.com>
Discussion: https://www.postgresql.org/message-id/3b8a9dc1-bbc7-0ef5-6863-c432afac7d59@gmail.com

Files

PathChange+/−
src/backend/catalog/pg_depend.c modified +29 −2
src/backend/commands/tablecmds.c modified +1 −1
src/backend/parser/parse_utilcmd.c modified +30 −22
src/backend/rewrite/rewriteHandler.c modified +1 −18
src/include/catalog/dependency.h modified +1 −1
src/test/regress/expected/identity.out modified +30 −2
src/test/regress/sql/identity.sql modified +9 −2

Discussion