On Thu, Mar 14, 2024 at 11:45 AM Quentin de Metz <quentin(at)de(dot)me(dot)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.