Re: DOC: fixes multiple errors in alter table doc - Mailing list pgsql-hackers

> On Mar 2, 2026, at 17:22, Chao Li <li.evan.chao@gmail.com> wrote:
>
>
>
>> On Mar 2, 2026, at 17:04, Fujii Masao <masao.fujii@gmail.com> wrote:
>>
>> On Thu, Jan 22, 2026 at 6:38 PM Chao Li <li.evan.chao@gmail.com> wrote:
>>> PFA v3: Rebased, and added reviewer and discussion information.
>>
>> LGTM.
>>
>> Should we apply the same change to the ALTER FOREIGN TABLE docs as well?
>
> Sure, I can make the change.
>
>>
>> While reviewing that section, I noticed that ADD COLUMN IF NOT EXISTS appears
>> to work for ALTER FOREIGN TABLE, but it isn't documented. I'm not sure why
>> it was left out, but perhaps we should document it and add a regression test in
>> a separate patch?
>>
>
> I will verify that, then update the doc and regression test accordingly.
>
> Best regards,
> --
> Chao Li (Evan)
> HighGo Software Co., Ltd.
> https://www.highgo.com/
>

PFA v4:

0001 - alter table related changes

 * Add test cases for omitting COLUMN of ALTER TABLE ADD/DROP [COLUMN]
 * Add a test case for ADD COLUMN IF NOT EXIST (already had DROP COLUMN IF EXIST)

0002 - alter foreign table related changes

 * doc: Add IF NOT EXSTS for ADD COLUMN
 * doc: Mark COLUMN as optional for ADD/DROP COLUMN in the same way as 0001
 * Add test cases for omitting COLUMN of ALTER FOREIGN TABLE ADD/DROP [COLUMN]
 * Add a test cases for for ADD COLUMN IF NOT EXIST
 * Add a test cases for for DROP COLUMN IF EXIST

Best regards,
--
Chao Li (Evan)
HighGo Software Co., Ltd.
https://www.highgo.com/