Re: how to add more than 1600 columns in a table?

From: Ron <ronljohnsonjr(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: how to add more than 1600 columns in a table?
Date: 2019-04-24 20:24:18
Message-ID: 42f8e861-4d12-0ceb-ad14-25d927e0db0d@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 4/24/19 3:22 PM, Adrian Klaver wrote:
> On 4/24/19 1:17 PM, pabloa98 wrote:
>> Hello
>>
>> Sadly today we hit the 1600 columns limit of Postgresql 11.
>>
>> How could we add more columns?
>>
>> Note: Tables are OK. We truly have 2400 columns now. Each column
>> represents a value in a matrix.
>
> Not sure how hit 1600 column limit = having 2400 columns?

I think he means that *the design* has 2400 columns, and Pg is failing to
implement it.

--
Angular momentum makes the world go 'round.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2019-04-24 20:27:06 Re: how to add more than 1600 columns in a table?
Previous Message Alvaro Herrera 2019-04-24 20:23:59 Re: how to add more than 1600 columns in a table?