Re: update db doesnt work
От | John Gray |
---|---|
Тема | Re: update db doesnt work |
Дата | |
Msg-id | 1022516212.1715.128.camel@adzuki обсуждение исходный текст |
Ответ на | Re: update db doesnt work (Gregory Seidman <gss+pg@cs.brown.edu>) |
Ответы |
Re: update db doesnt work
|
Список | pgsql-general |
On Mon, 2002-05-27 at 16:30, Gregory Seidman wrote: > 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? > Don't know what the answer is, but it would be interesting to confirm whether PG thinks there are only 1600 columns. Try: select relnatts from pg_class where relname='db'; I assume that says 1600? (I was wondering about catalogue changes such as ADD COLUMN, but that does seem to check MaxHeapAttributeNumber) Regards John -- John Gray Azuli IT www.azuli.co.uk
В списке pgsql-general по дате отправления: