Re: Some thoughts on table inheritance (which is uniquely awesome on PostgreSQL) - Mailing list pgsql-general

From Chris Travers
Subject Re: Some thoughts on table inheritance (which is uniquely awesome on PostgreSQL)
Date
Msg-id CAKt_ZfvB4q25+e0ZQGSF4CWBDd0z7Whyb=ofXy_VuoU41FTDEQ@mail.gmail.com
Whole thread Raw
In response to Re: Some thoughts on table inheritance (which is uniquely awesome on PostgreSQL)  (Chris Travers <chris.travers@gmail.com>)
List pgsql-general
One other thing that seems worth mentioning is that as soon as you
jump from relational to object-relational modelling is that the latter
is more rich and hence more complex than the former.  Because
object-relational modelling is a much expanded semantic superset of
relational modelling, the antipatterns are a much expanded superset
there too.  Additionally because the patterns are not yet well
understood, the whole area needs to be seen as somewhat immature.

That doesn't mean that the features are primarily useful as foot-guns,
but it does mean that productive use of features like this involves
careful documentation of patterns and antipatterns.

Best Wishes,
Chris Travers


pgsql-general by date:

Previous
From: Jeff Davis
Date:
Subject: Re: FETCH in subqueries or CTEs
Next
From: Craig Ringer
Date:
Subject: Re: Can column name aliases be supported?