PostgreSQL Limits: maximum number of columns in SELECT result

From: Vladimir Sitnikov <sitnikov(dot)vladimir(at)gmail(dot)com>
To: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: PostgreSQL Limits: maximum number of columns in SELECT result
Date: 2022-05-31 07:16:35
Message-ID: CAB=Je-E18aTYpNqje4mT0iEADpeGLSzwUvo3H9kRRuDdsNo4aQ@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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://stream.boxwatch.ru/docs/current/limits.html e.g.
after "columns per table".

Could someone please commit that 1-2 line doc improvement or do you need a
patch for it?

Vladimir

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Paquier 2022-05-31 07:17:01 Re: pg_upgrade test writes to source directory
Previous Message Peter Smith 2022-05-31 06:20:48 Re: Skipping schema changes in publication