Re: ERROR: tables can have at most 1600 columns - Mailing list pgsql-general

Hi all,

 

There is a way to actually eliminate those dropped tables so they don't affect the 1600 columns limit? I know it's very difficult to end up with this problem but apparently "it is" posible.

 

Thanx in advance,

 

Jaime Casanova

 

Tom Lane <tgl@sss.pgh.pa.us> wrote:

Alvaro Herrera writes:
> On Sun, Jun 27, 2004 at 11:11:32AM -0700, Ron St-Pierre wrote:
>> STATEMENT: ALTER TABLE victoria.eodData DROP COLUMN tickDate;
>> ERROR: tables can have at most 1600 columns
>> STATEMENT: ALTER TABLE victoria.eodData ADD COLUMN tickerID INTEGER;
>> ERROR: tables can have at most 1600 columns

> Have you done the DROP COLUMN/ADD COLUMN cycle to this table more than,
> say, 1500 times? Because a dropped column is actually only hidden from
> the user, but it's still present to the system and it will still affect
> the 1600 limit.

That is a good theory, but it doesn't quite explain why Ron's getting
the error from DROP COLUMN --- AFAICS, the places that would issue such
an error won't get called in that path.

I tried to reproduce this and could not: after 1600 cycles of adding and
dropping a column, I did indeed start to get "tables can have at most
1600 columns" from ADD, but DROP continued to behave normally.

Ron, are you sure these errors were coming from the DROPs and not only
the ADDs? Can you exhibit a test case?

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org