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
