Home > mailing lists

Re: Sharp edge when dropping columns - Mailing list pgsql-novice

From	David G. Johnston
Subject	Re: Sharp edge when dropping columns
Date	March 14 22:01:30
Msg-id	CAKFQuwYWYOu7LsdvD4k5uOgywnTXgfmt0UuSL2uP8=Q6izFqqg@mail.gmail.com Whole thread Raw
In response to	Sharp edge when dropping columns ("Quentin de Metz" <quentin@de.me.tz>)
List	pgsql-novice

Tree view

On Thu, Mar 14, 2024 at 11:45 AM Quentin de Metz <quentin@de.me.tz> wrote:

I found this behavior unexpected.

In general it is advisable to rely on documented behaviors rather than expectations.

https://www.postgresql.org/docs/current/sql-altertable.html

This long-standing behavior seems unlikely to be changed. Preventing the column from being dropped would in any case be the accepted outcome, not leaving an index behind that refers to a column that doesn't exist.

David J.

pgsql-novice by date:

From: "Quentin de Metz"
Date: 14 March, 21:44:31
Subject: Sharp edge when dropping columns

From: Tom Lane
Date: 14 March, 22:17:12
Subject: Re: Sharp edge when dropping columns

Re: Sharp edge when dropping columns - Mailing list pgsql-novice

Previous

Next