BUG #18911: Bug in the command INHERITS.

PG Bug reporting form <noreply@postgresql.org>

From: PG Bug reporting form <noreply@postgresql.org>
To: pgsql-bugs@lists.postgresql.org
Cc: bm16ch24f@gmail.com
Date: 2025-05-05T14:30:49Z
Lists: pgsql-bugs
The following bug has been logged on the website:

Bug reference:      18911
Logged by:          M. BROUSSE
Email address:      bm16ch24f@gmail.com
PostgreSQL version: 17.4
Operating system:   Windows 10 professional.
Description:        

Hello dev, sorry for my english i'm a french GIS user.
I'm actually using PostgreSQL with Postgis in an intership and if I don't do
mistake, I have discover the command INHERITS don't work as we would.
I have done a test with the exemple in the documentation with my data base.
The command gives all columns from the parent table (cities in the exemple)
to the child table ;  but attributs aren't given with tables to the child as
we would.
And more strange, if I create attributs by the child table, these attributs
are given to the parent table...
I have already used the Inheritance command before and it was normaly
working.
I don't know if someone have seen the same bug, and I hope I wasn't wrong
and that was normal.
Sorry for possible mistakes and I stay available if you need more details.
Have a good day.