Re: update db doesnt work

From: Gregory Seidman <gss+pg(at)cs(dot)brown(dot)edu>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: update db doesnt work
Date: 2002-05-27 15:30:12
Message-ID: 20020527113002.A20746@gandhi.cs.brown.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Jani Averbach sez:
} On Mon, 27 May 2002, dirk heitmann wrote:
} > i have created a table with 1600 comlumns. Now i want
} > to update some columns with new values:
} > update db set col1=1 where col2=2;
} >
} > this generates the error-message:
} > heap_formtuple: numberOfAttributes of 1601 > 1600.
}
} --8<--
} Maximum number of columns in a table 1600
} --8<--
} http://www2.se.postgresql.org/users-lounge/limitations.html

Which, while accurate, fails to answer the answer the question. A column is
not being added. A table is not being created. Rows are being updated and
the system is complaining that there are too many columns. Why?

} BR, Jani
--Greg

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John Gray 2002-05-27 16:16:49 Re: update db doesnt work
Previous Message Randal L. Schwartz 2002-05-27 15:01:15 [meta] news.postgresql.org still down - who do I complain to?