Re: BUG: pg_class.relchecks overflow, making table undroppable - Mailing list pgsql-hackers

From jian he
Subject Re: BUG: pg_class.relchecks overflow, making table undroppable
Date
Msg-id CACJufxEc=59a1+KRNzW4HKWYP8YifnRYK6F8KaCTOdXYTdwqrg@mail.gmail.com
Whole thread
In response to Re: BUG: pg_class.relchecks overflow, making table undroppable  (Bertrand Drouvot <bertranddrouvot.pg@gmail.com>)
List pgsql-hackers
On Fri, Sep 25, 2026 at 4:41 PM Bertrand Drouvot
<bertranddrouvot.pg@gmail.com> wrote:
>
>                                 numchecks++;
> +
> +                               if (numchecks >= PG_INT16_MAX)
> +                                       ereport(ERROR,
> +                                                       errmsg("too many check constraints on relation \"%s\"",
> +                                                                  RelationGetQualifiedRelationName(rel)));
>
Hi.

In MergeWithExistingConstraint, we have
```
else if (pg_add_s16_overflow(con->coninhcount, 1,
&con->coninhcount))
ereport(ERROR,
errcode(ERRCODE_PROGRAM_LIMIT_EXCEEDED),
errmsg("too many inheritance parents"));
```

here, we can also use pg_add_s16_overflow?



--
jian
https://www.enterprisedb.com/



pgsql-hackers by date:

Previous
From: Bertrand Drouvot
Date:
Subject: Re: BUG: pg_class.relchecks overflow, making table undroppable
Next
From: Michael Paquier
Date:
Subject: Re: WAL segment file descriptor leak on read errors can PANIC the server