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

On 2017-06-30 17:03:22 -0400, Peter Eisentraut wrote:
> 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?

"id" is not being updated in that statement?

- Andres


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