Horton

Re: Sharp edge when dropping columns

David G. Johnston <david.g.johnston@gmail.com>

View thread View on postgr.es
From: "David G. Johnston" <david.g.johnston@gmail.com>
To: Quentin de Metz <quentin@de.me.tz>
Cc: pgsql-novice@lists.postgresql.org
Date: 2024-03-14T19:01:30Z
Lists: pgsql-novice 
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.