# alter

Published articles for alter.

This is one page of public article previews, not the complete archive. Follow Next page to continue. Summaries are not the original full articles.

## Waiting for PostgreSQL 19 - Add support for EXCEPT TABLE in ALTER PUBLICATION.

DevFeed: [Waiting for PostgreSQL 19 - Add support for EXCEPT TABLE in ALTER PUBLICATION.](<https://devfeed.tech/articles/waiting-for-postgresql-19-add-support-for-except-table-in-alter-publication-33683.md>)

Original publisher: [Read original article](<https://www.depesz.com/2026/03/26/waiting-for-postgresql-19-add-support-for-except-table-in-alter-publication/>)

Author: depesz

Published: 2026-03-26T11:46:24Z

Content type: article

Language: en

Sources: [select \* from depesz;](<https://devfeed.tech/sources/select-from-depesz.md>)

Topics: [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [syntax](<https://devfeed.tech/topics/syntax.md>)

Tags: [alter](<https://devfeed.tech/tags/alter.md>), [commit](<https://devfeed.tech/tags/commit.md>), [except](<https://devfeed.tech/tags/except.md>), [logical](<https://devfeed.tech/tags/logical.md>), [pg19](<https://devfeed.tech/tags/pg19.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [publication](<https://devfeed.tech/tags/publication.md>), [replication](<https://devfeed.tech/tags/replication.md>), [table](<https://devfeed.tech/tags/table.md>), [uncategorized](<https://devfeed.tech/tags/uncategorized.md>), [waiting](<https://devfeed.tech/tags/waiting.md>)

### AI overview

This article discusses a PostgreSQL 19 patch adding EXCEPT TABLE support to ALTER PUBLICATION. The change allows modifying a publication's table exclusion list, though the example notes that specifying an exclusion for one publication replaced its previous exclusion list.

### Source excerpt

On 20th of March 2026, Amit Kapila committed patch: Add support for EXCEPT TABLE in ALTER PUBLICATION. Following commit fd366065e0, which added EXCEPT TABLE support to CREATE PUBLICATION, this commit extends ALTER PUBLICATION to allow modifying the exclusion list. New Syntax: ALTER PUBLICATION name SET publication_all_object [, ... ] where publication_all_object is ... Continue reading "Waiting for PostgreSQL 19 - Add support for EXCEPT TABLE in ALTER PUBLICATION."

## PostgreSQL Data Types: ENUM

DevFeed: [PostgreSQL Data Types: ENUM](<https://devfeed.tech/articles/postgresql-data-types-enum-34596.md>)

Original publisher: [Read original article](<https://tapoueh.org/blog/2018/05/postgresql-data-types-enum/>)

Author: Dimitri Fontaine PostgreSQL Major Contributor; Author

Published: 2018-05-02T09:00:26Z

Content type: tutorial

Language: en

Sources: [Dimitri Fontaine](<https://devfeed.tech/sources/dimitri-fontaine.md>)

Topics: [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [data type](<https://devfeed.tech/topics/data-type.md>), [enum](<https://devfeed.tech/topics/enum.md>), [MySQL](<https://devfeed.tech/topics/mysql.md>)

Tags: [alter](<https://devfeed.tech/tags/alter.md>), [data-type](<https://devfeed.tech/tags/data-type.md>), [database](<https://devfeed.tech/tags/database.md>), [enum](<https://devfeed.tech/tags/enum.md>), [join](<https://devfeed.tech/tags/join.md>), [mysql](<https://devfeed.tech/tags/mysql.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [table](<https://devfeed.tech/tags/table.md>)

### AI overview

This tutorial compares PostgreSQL ENUM types with reference tables and foreign keys. It explains how PostgreSQL registers ENUM types, how values are stored, and why changing accepted values is a DDL operation with transaction restrictions. The article recommends ENUMs for very static value sets and reference tables when values or ordering may change.

### Source excerpt

Continuing our series of PostgreSQL Data Types today we're going to introduce the PostgreSQL ENUM type. This data type has been added to PostgreSQL in order to make it easier to support migrations from MySQL. Proper relational design would use a reference table and a foreign key instead.

## MySQL Migrations

DevFeed: [MySQL Migrations](<https://devfeed.tech/articles/mysql-migrations-35617.md>)

Original publisher: [Read original article](<https://zolmeister.com/2016/08/mysql-migrations.html>)

Author: Zoli Kahan

Published: 2016-08-27T05:00:00Z

Content type: tutorial

Language: en

Sources: [Zolmeister](<https://devfeed.tech/sources/zolmeister.md>)

Topics: [MySQL](<https://devfeed.tech/topics/mysql.md>), [migration](<https://devfeed.tech/topics/migration.md>), [Database](<https://devfeed.tech/topics/database.md>), [Docker](<https://devfeed.tech/topics/docker.md>)

Tags: [alter](<https://devfeed.tech/tags/alter.md>), [avoid](<https://devfeed.tech/tags/avoid.md>), [database](<https://devfeed.tech/tags/database.md>), [docker](<https://devfeed.tech/tags/docker.md>), [downtime](<https://devfeed.tech/tags/downtime.md>), [migrations](<https://devfeed.tech/tags/migrations.md>), [mysql](<https://devfeed.tech/tags/mysql.md>)

### AI overview

This article describes migrating 17 million rows in MySQL without downtime while a table continues receiving reads and writes. It explains using Large Hadron Migrator to copy the table and track new writes with triggers, adjusting migration speed to avoid write timeouts, and running the process in a Docker container. The migration ultimately took more than 20 hours, and cleanup was manual if problems occurred.

### Source excerpt

MySQL Migrations Migrating 17M rows with no downtime - Isotope Scenario: 17M rows in a table, constant writes/reads, slave/master setup. If you try to run an ALTER TABLE (especially on older versions of MySQL), most operations will lock the table for writes for the entire run-time of the query. To avoid this, we need to incrementally update the table, incorporating write changes as they arrive. Our solution was to use the Large Hadron Migrator, built and open-sourced by SoundCloud.

## Tables and Views dependencies

DevFeed: [Tables and Views dependencies](<https://devfeed.tech/articles/tables-and-views-dependencies-34418.md>)

Original publisher: [Read original article](<https://tapoueh.org/blog/2011/05/tables-and-views-dependencies/>)

Author: Dimitri Fontaine PostgreSQL Major Contributor; Author

Published: 2011-05-04T09:45:00Z

Content type: tutorial

Language: en

Sources: [Dimitri Fontaine](<https://devfeed.tech/sources/dimitri-fontaine.md>)

Topics: [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [Query (disambiguation)](<https://devfeed.tech/topics/query.md>)

Tags: [alter](<https://devfeed.tech/tags/alter.md>), [locking](<https://devfeed.tech/tags/locking.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [script](<https://devfeed.tech/tags/script.md>), [table](<https://devfeed.tech/tags/table.md>), [view](<https://devfeed.tech/tags/view.md>)

### AI overview

This tutorial explains how to handle PostgreSQL ALTER TABLE operations when dependent views prevent a column type change. It describes using system catalog queries to identify affected views and generate scripts for dropping, altering, and recreating them, while noting that the query may produce false-positive candidates.

### Source excerpt

Let's say you need to ALTER TABLE foo ALTER COLUMN bar TYPE bigint;, and PostgreSQL is helpfully telling you that no you can't because such and such views depend on the column. The basic way to deal with that is to copy paste from the error message the names of the views involved, then prepare a script wherein you first DROP VIEW then ALTER TABLE and finally CREATE VIEW again, all in the same transaction.