Re: Inheritance in PostgreSQL

On Wed, Oct 18, 2023 at 7:43 AM Thomas Kellerer wrote: > Merlin Moncure schrieb am 18.10.2023 um 03:20: > > The only thing you can't really do in SQL easily without writing > > nasty triggers are things like, 'this table must be linked from one > > and only one of these candidate tables'. I thin

Re: Inheritance in PostgreSQL

Merlin Moncure schrieb am 18.10.2023 um 03:20: > The only thing you can't really do in SQL easily without writing > nasty triggers are things like, 'this table must be linked from one > and only one of these candidate tables'. I think the language > probably ought to support this, but I don't thin

Re: Inheritance in PostgreSQL

> Thank you all for your responses. I appreciate the input on the use of > table inheritance in PostgreSQL, and I will take your recommendations into > consideration. The provided link is also quite useful, and I'm grateful for > the solution provided by Ron regarding normalization. Thanks! >

Re: Inheritance in PostgreSQL

On Tue, Oct 17, 2023 at 5:36 PM Jeff Laing wrote: > “Don’t use table inheritance” IS on that page > Yeah, inheritance probably would have been removed a long time ago except that it was underneath the partitioning feature. The basic idea of implementing polymorphic record storage essentially ha

Re: Inheritance in PostgreSQL

On Tue, Oct 17, 2023 at 3:33 PM Jeff Laing wrote: > “Don’t use table inheritance” IS on that page > > > Indeed - oddly under "tool usage"...along with rules and, an actual tool, psql -W David J.

RE: Inheritance in PostgreSQL

“Don’t use table inheritance” IS on that page From: David G. Johnston Also of note: https://wiki.postgresql.org/wiki/Don%27t_Do_This#Don.27t_use_varchar.28n.29_by_default

Re: Inheritance in PostgreSQL

On 10/17/23 16:42, Luis Bruno wrote: Hello, I'm in the process of developing a basic database structure that utilizes inheritance as part of a test for my work. The database consists of two tables: ‘PERSON' and ‘CUSTOMER' with the ‘PERSON' table serving as the parent table for ‘CUSTOMER' .

Re: Inheritance in PostgreSQL

On Tue, Oct 17, 2023 at 2:49 PM Luis Bruno wrote: > I'm particularly interested in the advantages of the inheritance concept > in PostgreSQL > There really are none nowadays and the entire feature should be avoided, IMO. No one else has tried to implement it in their engines for good reasons.