Bug:Create a table with 1600 fields (reaching the upper limit), then drop several fields and create new ones, but the addition failed.

From: BO ST <1599224321(at)qq(dot)com>
To: pgsql-bugs <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: Bug:Create a table with 1600 fields (reaching the upper limit), then drop several fields and create new ones, but the addition failed.
Date: 2023-05-04 15:51:03
Message-ID: tencent_F16D1126BC04AF612DC48B7C5C1DDE64FC05@qq.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Create a table with 1600 fields (reaching the upper limit), then drop several fields and create new ones, but the addition failed.

test=# alter table t1 add column co1599 int;
ALTER TABLE
test=# alter table t1 add column co1600 int;
ALTER TABLE

test=# alter table t1 add column co1601 int;
psql: ERROR:&nbsp; table can have at most 1600 columns

then, I drop column co1600 and add it again, failed:

test=# alter table t1 drop column co1600;
ALTER TABLE
test=# alter table t1 add column co1600 int;
psql:&nbsp;ERROR:&nbsp; table can have at most 1600 columns

then, I drop column co1600 again:

test=# alter table t1 drop column co1600;
psql:&nbsp;ERROR: column "co1600" of relation "t1" dose not exist

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2023-05-04 15:53:48 Re: BUG #17920: Incorrect memory access in array_position(s) is detected (or not)
Previous Message Tom Lane 2023-05-04 15:26:58 Re: BUG #17912: Invalid memory access when converting plpython' array containing empty array