The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/15/sql-altertable.html Description:
Hello dear PostgreSQL family, It is not entirely clear (to me) that ALTER TABLE statements with comma-separated sub-commands are atomic. Despite of saying "perform X actions in one operation" in one of the examples, it is not explicitly said that the operation will be rolled back if one of the sub-commands fails. From the examples, we have: ALTER TABLE distributors ALTER COLUMN address TYPE varchar(80), ALTER COLUMN name TYPE varchar(100); Will the `address` column type change rollback if the `ALTER COLUMN name TYPE varchar(100)` subcommand fails? Currently reading the docs for version 15. Many thanks :)