Re: BUG #14718: unable to update table with identity column GENERATED ALWAYS

On 6/26/17 15:22, zam6ak(at)gmail(dot)com wrote:
> -- create tbl1
> create table tbl1 (
> id bigint GENERATED ALWAYS AS IDENTITY PRIMARY KEY, -- fails
> --id bigint GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY, -- works
> name text NOT NULL
> );
> -- add some values
> insert into tbl1 (name) values ('Tommy');
> -- verify
> select * from tbl1; -- 1;"Tommy"
>
> -- 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.

Fix committed. Thanks for the report.

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