Re: update db doesnt work

Поиск
Список
Период
Сортировка
От Gregory Seidman
Тема Re: update db doesnt work
Дата
Msg-id 20020527113002.A20746@gandhi.cs.brown.edu
обсуждение исходный текст
Ответ на Re: update db doesnt work  (Jani Averbach <jaa@cc.jyu.fi>)
Ответы Re: update db doesnt work  (John Gray <jgray@azuli.co.uk>)
Re: update db doesnt work  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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


В списке pgsql-general по дате отправления:

Предыдущее
От: merlyn@stonehenge.com (Randal L. Schwartz)
Дата:
Сообщение: [meta] news.postgresql.org still down - who do I complain to?
Следующее
От: John Gray
Дата:
Сообщение: Re: update db doesnt work