Postgres Pro
Downloads
Home   >   mailing lists

PostgreSQL Limits: maximum number of columns in SELECT result - Mailing list pgsql-hackers

From Vladimir Sitnikov
Subject PostgreSQL Limits: maximum number of columns in SELECT result
Date
Msg-id CAB=Je-E18aTYpNqje4mT0iEADpeGLSzwUvo3H9kRRuDdsNo4aQ@mail.gmail.com
Whole thread Raw
Responses Re: PostgreSQL Limits: maximum number of columns in SELECT result
List pgsql-hackers
Tree view
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".

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

Vladimir

pgsql-hackers by date:

Previous
From: Peter Smith
Date:
Subject: Re: Skipping schema changes in publication
Next
From: Michael Paquier
Date:
Subject: Re: pg_upgrade test writes to source directory