Re: 42P16 error when dropping and adding column - Mailing list pgsql-bugs

On Fri, Sep 18, 2026 at 12:01 AM Manuel Reyes Bravo
<manuelreyesbravo@gmail.com> wrote:
> v1's test covers the DROP COLUMN form only.  The attached top-up adds
> the three commands above to the same place in alter_table.sql.

Thanks! Attached is v2 patch, which includes your tests.

While working with the v1 patch, I found that the following DDL failed even
though it succeeds without the patch. v2 fixes this regression introduced by
v1.

CREATE TABLE t (id int NOT NULL);
ALTER TABLE t
  ALTER COLUMN id DROP NOT NULL,
  ADD PRIMARY KEY (id),
  ADD CONSTRAINT hoge NOT NULL id;

Regards,

--
Fujii Masao