Re: [BUGS] BUG #14718: unable to update table with identity columnGENERATED ALWAYS

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: [BUGS] BUG #14718: unable to update table with identity columnGENERATED ALWAYS
Дата
Msg-id 92d274cb-ebc2-aac3-0d0d-390c5585a547@2ndquadrant.com
обсуждение исходный текст
Ответ на [BUGS] BUG #14718: unable to update table with identity column GENERATEDALWAYS  (zam6ak@gmail.com)
Ответы Re: [BUGS] BUG #14718: unable to update table with identity columnGENERATED ALWAYS  (Andres Freund <andres@anarazel.de>)
[BUGS] Re: BUG #14718: unable to update table with identity column GENERATEDALWAYS  (Thomas Kellerer <spam_eater@gmx.net>)
Список pgsql-bugs
Дерево обсуждения 
On 6/26/17 15:22, zam6ak@gmail.com wrote:
> -- now try to update
> update tbl1 set name = 'Bobby' where id = 1;
> 
> ERROR:  column "id" can only be updated to DEFAULT
> DETAIL:  Column "id" is an identity column defined as GENERATED ALWAYS.

This is working as expected.  What is the problem?

-- 
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services


-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

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

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: [BUGS] Fixed PL/Python hint about array of composites
Следующее
От: Andres Freund
Дата:
Сообщение: Re: [BUGS] BUG #14718: unable to update table with identity columnGENERATED ALWAYS