> > > > > On Tue, 31 May 2022 at 09:56, Amul Sul <sula...@gmail.com> wrote: > >> On Tue, May 31, 2022 at 12:46 PM Vladimir Sitnikov >> <sitnikov.vladi...@gmail.com> wrote: >> > >> > Hi, >> > >> > Today I hit "ERROR: target lists can have at most 1664 entries", and I >> was surprised the limit was not documented. >> > >> > I suggest that the limit of "1664 columns per tuple" (or whatever is >> the right term) should be added >> > to the list at https://www.postgresql.org/docs/current/limits.html >> e.g. after "columns per table". >> > >> >> Rather, I think the "columns per table" limit needs to be updated to 1664. >> > > Actually that is correct. Columns per table is MaxHeapAttributeNumber > which is 1600. > > MaxTupleAttributeNumber is 1664 and is the limit of user columns in a > tuple. > > Dave >
Attached is a patch to limits.sgml. I'm not sure this is where it belongs, as it's not a physical limit per-se but I am not familiar enough with the docs to propose another location. Note this was suggested by Vladimir. see attached
columns_per_tuple.patch
Description: Binary data
