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.

Inheritance in PostgreSQL

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' . Initially, I defined the 'CREATE TABLE' stat