| From: | Francisco Olarte <folarte(at)peoplecall(dot)com> |
|---|---|
| To: | José Luis Viejo <jlviejo(at)gmail(dot)com> |
| Cc: | Michael Paquier <michael(at)paquier(dot)xyz>, pgsql-bugs(at)lists(dot)postgresql(dot)org |
| Subject: | Re: identity not working with inherited table |
| Date: | 2019-05-05 11:15:57 |
| Message-ID: | CA+bJJbxbAVCc+h=eUmyA_TiJmDDiaG0xCoMm79EAaOCtyUpS7A@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
Seems like pilot error ( rtfm )?...
On Sun, May 5, 2019 at 12:50 PM José Luis Viejo <jlviejo(at)gmail(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Euler Taveira | 2019-05-06 01:16:39 | Re: BUG #15791: WalSndCtl->sync_standbys_defined modified too late |
| Previous Message | José Luis Viejo | 2019-05-05 10:49:48 | Re: identity not working with inherited table |