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