pg.ddx.io pgsql-bugs@postgresql.org mailing list archive
help / color / mirror / Atom feedBUG #18911: Bug in the command INHERITS.
7+ messages / 4 participants
[nested] [flat]
* BUG #18911: Bug in the command INHERITS.
@ 2025-05-05 14:30 PG Bug reporting form <noreply@postgresql.org>
2025-05-05 15:30 ` Re: BUG #18911: Bug in the command INHERITS. David G. Johnston <david.g.johnston@gmail.com>
2025-05-06 15:39 ` Re: BUG #18911: Bug in the command INHERITS. David G. Johnston <david.g.johnston@gmail.com>
0 siblings, 2 replies; 7+ messages in thread
From: PG Bug reporting form @ 2025-05-05 14:30 UTC (permalink / raw)
To: pgsql-bugs@lists.postgresql.org; +Cc: bm16ch24f@gmail.com
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.
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: BUG #18911: Bug in the command INHERITS.
2025-05-05 14:30 BUG #18911: Bug in the command INHERITS. PG Bug reporting form <noreply@postgresql.org>
@ 2025-05-05 15:30 ` David G. Johnston <david.g.johnston@gmail.com>
1 sibling, 0 replies; 7+ messages in thread
From: David G. Johnston @ 2025-05-05 15:30 UTC (permalink / raw)
To: bm16ch24f@gmail.com <bm16ch24f@gmail.com>; pgsql-bugs@lists.postgresql.org <pgsql-bugs@lists.postgresql.org>
On Monday, May 5, 2025, PG Bug reporting form <noreply@postgresql.org>
wrote:
> 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:
>
> Sorry for possible mistakes and I stay available if you need more details.
> Have a good day.
>
>
Yes, providing the code that demonstrates the bug you are reporting is
basically a requirement for reporting bugs.
David J.
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: BUG #18911: Bug in the command INHERITS.
2025-05-05 14:30 BUG #18911: Bug in the command INHERITS. PG Bug reporting form <noreply@postgresql.org>
@ 2025-05-06 15:39 ` David G. Johnston <david.g.johnston@gmail.com>
2025-05-07 07:00 ` Re: BUG #18911: Bug in the command INHERITS. M. BROUSSE <bm16ch24f@gmail.com>
1 sibling, 1 reply; 7+ messages in thread
From: David G. Johnston @ 2025-05-06 15:39 UTC (permalink / raw)
To: bm16ch24f@gmail.com; pgsql-bugs@lists.postgresql.org
On Mon, May 5, 2025 at 7:46 AM PG Bug reporting form <noreply@postgresql.org>
wrote:
> 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:
>
>
Based upon an off-list reply I've determined there is no bug here.
David J.
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: BUG #18911: Bug in the command INHERITS.
2025-05-05 14:30 BUG #18911: Bug in the command INHERITS. PG Bug reporting form <noreply@postgresql.org>
2025-05-06 15:39 ` Re: BUG #18911: Bug in the command INHERITS. David G. Johnston <david.g.johnston@gmail.com>
@ 2025-05-07 07:00 ` M. BROUSSE <bm16ch24f@gmail.com>
2025-05-07 13:33 ` Re: BUG #18911: Bug in the command INHERITS. David G. Johnston <david.g.johnston@gmail.com>
2025-05-07 14:59 ` Re: BUG #18911: Bug in the command INHERITS. Álvaro Herrera <alvherre@kurilemu.de>
0 siblings, 2 replies; 7+ messages in thread
From: M. BROUSSE @ 2025-05-07 07:00 UTC (permalink / raw)
To: David G. Johnston <david.g.johnston@gmail.com>; +Cc: pgsql-bugs@lists.postgresql.org
I'm a little confused because I already used inheritance on PostgreSQL 16
and attributes were given to children tables. So, is it normal that
attributes aren't given to children, if you said so.
Thanks for the help, have a nice day.
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: BUG #18911: Bug in the command INHERITS.
2025-05-05 14:30 BUG #18911: Bug in the command INHERITS. PG Bug reporting form <noreply@postgresql.org>
2025-05-06 15:39 ` Re: BUG #18911: Bug in the command INHERITS. David G. Johnston <david.g.johnston@gmail.com>
2025-05-07 07:00 ` Re: BUG #18911: Bug in the command INHERITS. M. BROUSSE <bm16ch24f@gmail.com>
@ 2025-05-07 13:33 ` David G. Johnston <david.g.johnston@gmail.com>
1 sibling, 0 replies; 7+ messages in thread
From: David G. Johnston @ 2025-05-07 13:33 UTC (permalink / raw)
To: M. BROUSSE <bm16ch24f@gmail.com>; +Cc: pgsql-bugs@lists.postgresql.org <pgsql-bugs@lists.postgresql.org>
On Wednesday, May 7, 2025, M. BROUSSE <bm16ch24f@gmail.com> wrote:
> I'm a little confused because I already used inheritance on PostgreSQL 16
> and attributes were given to children tables.
>
>
Show that happening.
David J.
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: BUG #18911: Bug in the command INHERITS.
2025-05-05 14:30 BUG #18911: Bug in the command INHERITS. PG Bug reporting form <noreply@postgresql.org>
2025-05-06 15:39 ` Re: BUG #18911: Bug in the command INHERITS. David G. Johnston <david.g.johnston@gmail.com>
2025-05-07 07:00 ` Re: BUG #18911: Bug in the command INHERITS. M. BROUSSE <bm16ch24f@gmail.com>
@ 2025-05-07 14:59 ` Álvaro Herrera <alvherre@kurilemu.de>
2025-05-08 11:27 ` Re: BUG #18911: Bug in the command INHERITS. M. BROUSSE <bm16ch24f@gmail.com>
1 sibling, 1 reply; 7+ messages in thread
From: Álvaro Herrera @ 2025-05-07 14:59 UTC (permalink / raw)
To: M. BROUSSE <bm16ch24f@gmail.com>; +Cc: David G. Johnston <david.g.johnston@gmail.com>; pgsql-bugs@lists.postgresql.org
On 2025-May-07, M. BROUSSE wrote:
> I'm a little confused because I already used inheritance on PostgreSQL 16
> and attributes were given to children tables. So, is it normal that
> attributes aren't given to children, if you said so.
Please explain what you mean by "attributes". Most people here
consider "attribute" to be a synonym for "column", but I noticed that
you used both the terms in your first email as if you meant two
different things.
It helps if you show the exact commands you run (to create the
parent/child tables in an empty database), the output you get, and
explain how that output differs from the output you expect.
--
Álvaro Herrera PostgreSQL Developer — https://www.EnterpriseDB.com/
"You don't solve a bad join with SELECT DISTINCT" #CupsOfFail
https://twitter.com/connor_mc_d/status/1431240081726115845
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: BUG #18911: Bug in the command INHERITS.
2025-05-05 14:30 BUG #18911: Bug in the command INHERITS. PG Bug reporting form <noreply@postgresql.org>
2025-05-06 15:39 ` Re: BUG #18911: Bug in the command INHERITS. David G. Johnston <david.g.johnston@gmail.com>
2025-05-07 07:00 ` Re: BUG #18911: Bug in the command INHERITS. M. BROUSSE <bm16ch24f@gmail.com>
2025-05-07 14:59 ` Re: BUG #18911: Bug in the command INHERITS. Álvaro Herrera <alvherre@kurilemu.de>
@ 2025-05-08 11:27 ` M. BROUSSE <bm16ch24f@gmail.com>
0 siblings, 0 replies; 7+ messages in thread
From: M. BROUSSE @ 2025-05-08 11:27 UTC (permalink / raw)
To: Álvaro Herrera <alvherre@kurilemu.de>; +Cc: David G. Johnston <david.g.johnston@gmail.com>; pgsql-bugs@lists.postgresql.org
For creating the parents and child tables I used the same command as the
exemple in the documentation (like the picture attached to the mail).
I expected from the inheritance to give all information inside the parent
table to the child table, but obviously I was wrong.
And sorry but like I said in my previous email, I don't have anymore my
project where I used the same command and where I had doubts.
Don't worry for me, I asked because I thought it was a bug and I was
searching for a method for creating an exact copy of an existing table.
Don't waste your time for my mistake, I was just wrong.
Thank you so much for explaining and taking your time for me.
Have a nice day, sincerely.
Le mer. 7 mai 2025 à 17:00, Álvaro Herrera <alvherre@kurilemu.de> a écrit :
> On 2025-May-07, M. BROUSSE wrote:
>
> > I'm a little confused because I already used inheritance on PostgreSQL 16
> > and attributes were given to children tables. So, is it normal that
> > attributes aren't given to children, if you said so.
>
> Please explain what you mean by "attributes". Most people here
> consider "attribute" to be a synonym for "column", but I noticed that
> you used both the terms in your first email as if you meant two
> different things.
>
> It helps if you show the exact commands you run (to create the
> parent/child tables in an empty database), the output you get, and
> explain how that output differs from the output you expect.
>
> --
> Álvaro Herrera PostgreSQL Developer —
> https://www.EnterpriseDB.com/
> "You don't solve a bad join with SELECT DISTINCT" #CupsOfFail
> https://twitter.com/connor_mc_d/status/1431240081726115845
>
Attachments:
[image/png] command inheritance.png (8.3K, ../../CACZU=tAfq0Og9OJ0rK0x1NRM8_AGNSTpDwS5GVKQqUF6EKpchg@mail.gmail.com/3-command%20inheritance.png)
download | view image
^ permalink raw reply [nested|flat] 7+ messages in thread
end of thread, other threads:[~2025-05-08 11:27 UTC | newest]
Thread overview: 7+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2025-05-05 14:30 BUG #18911: Bug in the command INHERITS. PG Bug reporting form <noreply@postgresql.org>
2025-05-05 15:30 ` David G. Johnston <david.g.johnston@gmail.com>
2025-05-06 15:39 ` David G. Johnston <david.g.johnston@gmail.com>
2025-05-07 07:00 ` M. BROUSSE <bm16ch24f@gmail.com>
2025-05-07 13:33 ` David G. Johnston <david.g.johnston@gmail.com>
2025-05-07 14:59 ` Álvaro Herrera <alvherre@kurilemu.de>
2025-05-08 11:27 ` M. BROUSSE <bm16ch24f@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox