Re: identity not working with inherited table - Mailing list pgsql-bugs

From Francisco Olarte
Subject Re: identity not working with inherited table
Date
Msg-id CA+bJJbz_EEceddC5PTgCdvKXz=eTvR09Zow1bVydOccD3FJYFA@mail.gmail.com
Whole thread Raw
In response to Re: identity not working with inherited table  (Euler Taveira <euler@timbira.com.br>)
Responses Re: identity not working with inherited table  (Euler Taveira <euler@timbira.com.br>)
List pgsql-bugs
Euler:

On Mon, May 6, 2019 at 3:46 AM Euler Taveira <euler@timbira.com.br> wrote:
> Em dom, 5 de mai de 2019 às 08:16, Francisco Olarte
> <folarte@peoplecall.com> escreveu:
> > "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."
> Although, it is documented, it seems inconsistent with sequence
> behavior (child table inherits sequences). Since sequences are
> inherited I think identity columns (that use implicit sequences)
> should be inherited as well. It seems an oversight in the current
> implementation, however, I see it as a new feature.

I'm not sure what you mean by "inherits sequence", may be you mean
"inherits default values" ( specifically on serial ) ?

I do not know the reason, but that is what the docs are for. You hit a
glitch, you RTFM a bit before spamming the bugs list. Then you
consider it a short coming and ask about it / request a feature  on
the general / hackers list where more knowledgeable people may give
you some insight ( they tend to be busy, and may see it and dismiss it
as "another one who does not bother to read the docs ).

If you see it as a feature, why do you report it as a bug?

>    Euler Taveira                                   Timbira -
> http://www.timbira.com.br/
>    PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento

And, given your sig, you should have done it. I'm just an ocasional
user and found it in the docs in about a dozen seconds.

Francisco Olarte.



pgsql-bugs by date:

Previous
From: "Bossart, Nathan"
Date:
Subject: Re: BUG #15788: 'pg_dump --create' orders database GRANTs incorrectly
Next
From: Euler Taveira
Date:
Subject: Re: identity not working with inherited table