Re: [GENERAL] Some thoughts on table inheritance (which is uniquely awesome on PostgreSQL)

2012-08-26 Thread Wolfgang Keller
1) First, in LedgerSMB, duck What a pity that this is implemented in a write-only programming language and as a web application instead of an actual GUI... /duck we started using it to create consistent interfaces to sets of storage tables. The storage tables would behave differently,

Re: [GENERAL] Some thoughts on table inheritance (which is uniquely awesome on PostgreSQL)

2012-08-26 Thread Chris Travers
On Aug 27, 2012 12:58 AM, Wolfgang Keller felip...@gmx.net wrote: 1) First, in LedgerSMB, duck What a pity that this is implemented in a write-only programming language and as a web application instead of an actual GUI... /duck Actually this has continued to remind me how ugly HTTP is

Re: [GENERAL] Some thoughts on table inheritance (which is uniquely awesome on PostgreSQL)

2012-08-23 Thread Merlin Moncure
On Wed, Aug 22, 2012 at 10:22 PM, Chris Travers chris.trav...@gmail.com wrote: I have now been working with table inheritance for a while and after starting to grapple with many of the use cases it has have become increasingly impressed with this feature. I also think that some of the

Re: [GENERAL] Some thoughts on table inheritance (which is uniquely awesome on PostgreSQL)

2012-08-23 Thread Chris Travers
On Thu, Aug 23, 2012 at 12:36 PM, Merlin Moncure mmonc...@gmail.com wrote: On Wed, Aug 22, 2012 at 10:22 PM, Chris Travers chris.trav...@gmail.com wrote: I have now been working with table inheritance for a while and after starting to grapple with many of the use cases it has have become

Re: [GENERAL] Some thoughts on table inheritance (which is uniquely awesome on PostgreSQL)

2012-08-23 Thread Chris Travers
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

Re: [GENERAL] Some thoughts on table inheritance (which is uniquely awesome on PostgreSQL)

2012-08-23 Thread Ondrej Ivanič
Hi, On 24 August 2012 11:44, Chris Travers chris.trav...@gmail.com wrote: One thing I have found looking through Oracle and DB2 docs is that their table inheritance seems to have all the same problems as ours and their solutions to these problems seem rather broken from a pure relational

[GENERAL] Some thoughts on table inheritance (which is uniquely awesome on PostgreSQL)

2012-08-22 Thread Chris Travers
I have now been working with table inheritance for a while and after starting to grapple with many of the use cases it has have become increasingly impressed with this feature. I also think that some of the apparent limitations fundamentally follow from the support for multiple inheritance, and

Re: [GENERAL] Some thoughts on table inheritance (which is uniquely awesome on PostgreSQL)

2012-08-22 Thread David Johnston
On Aug 22, 2012, at 23:22, Chris Travers chris.trav...@gmail.com wrote: * unique constraints being able to be marked INHERIT or NOINHERIT. A unique constraint that is marked INHERIT would be automatically created again on the child table. This could be documented to be domain-specific to