Seems like pilot error ( rtfm )?...
On Sun, May 5, 2019 at 12:50 PM José Luis Viejo <jlviejo@gmail.com> wrote:
> I'm using PostgreSQL 11 latest version, having problems with an identity as PK that inherits a table.
https://www.postgresql.org/docs/11/sql-createtable.html says in the
description of the inherits cluase of create table:
"If a column in the parent table is an identity column, that property
is not inherited. A column in the child table can be declared identity
column if desired."
So
> ERROR: null value in column "id_t7" violates not-null constraint
> DETAIL: Failing row contains (null, null, 20797, t, 101, 2019-05-03 22:27:54.823894).
Seems to be working exactly as documented, not-null inherited, identity not.
F.O.
