Postgres Pro
Downloads
Home   >   mailing lists

Re: INSERT ON CONFLICT of "wide" table: target lists can have at most 1664 entries - Mailing list pgsql-general

From Tom Lane
Subject Re: INSERT ON CONFLICT of "wide" table: target lists can have at most 1664 entries
Date
Msg-id 19399.1480881925@sss.pgh.pa.us
Whole thread Raw
In response to INSERT ON CONFLICT of "wide" table: target lists can have at most 1664 entries  (Justin Pryzby <pryzby@telsasoft.com>)
List pgsql-general
Tree view 
Justin Pryzby <pryzby@telsasoft.com> writes:
> I'm implementing unique indices to allow "upsert" (and pg_repack and..), but
> running into a problem when the table has >830 columns (we have some tables
> which are at the 1600 column limit, and have previously worked around that
> limit using arrays or multiple tables).

Yeah, this is a bug, but fortunately the fix is pretty trivial.  See

https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=da05d0ebc637a84ba41a172b32552557ebad199f

            regards, tom lane

pgsql-general by date:

Previous
From: Rich Shepard
Date:
Subject: Re: Postgres and LibreOffice's 'Base'
Next
From: Adrian Klaver
Date:
Subject: Re: Postgres and LibreOffice's 'Base'