Re: INSERT ON CONFLICT of "wide" table: target lists can have at most 1664 entries

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: INSERT ON CONFLICT of "wide" table: target lists can have at most 1664 entries
Дата
Msg-id 19399.1480881925@sss.pgh.pa.us
обсуждение исходный текст
Ответ на INSERT ON CONFLICT of "wide" table: target lists can have at most 1664 entries  (Justin Pryzby <pryzby@telsasoft.com>)
Список pgsql-general
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 по дате отправления:

Предыдущее
От: Rich Shepard
Дата:
Сообщение: Re: Postgres and LibreOffice's 'Base'
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: Postgres and LibreOffice's 'Base'