Re: [SQL] Design problemi : using the same primary keys for inherited objects.

2005-10-17 Thread David Pradier
Well yes, i find your system very interesting and will maybe use it as solution for another problem we have ( :-) ), but i fail to see where it makes use of a primary key referencing another primary key ? On Fri, Oct 14, 2005 at 08:29:40AM -0700, codeWarrior wrote: > I dont consider this to be a

Re: [SQL] Design problemi : using the same primary keys for inherited objects.

2005-10-14 Thread codeWarrior
I dont consider this to be a design problem... In fact... I do the inherited table thing pretty routinely... It (table inheritance) works very well if you need to implement a Sarbanes-Oxley audit trail or a "virtual" rollback system without the overhead of managing transactions. Consider the re

Re: [SQL] Design problemi : using the same primary keys for inherited objects.

2005-10-14 Thread Russell Simpkins
- Original Message - i've got a strange design question to ask you.It's something I couldn't answer to while feeling confusely it was anabsolutely BAD thing to do.For our application, we have developed our own framework which sits ontop of PostgreSQL. It uses object progr

[SQL] Design problemi : using the same primary keys for inherited objects.

2005-10-14 Thread David Pradier
Hi everybody, i've got a strange design question to ask you. It's something I couldn't answer to while feeling confusely it was an absolutely BAD thing to do. For our application, we have developed our own framework which sits on top of PostgreSQL. It uses object programming and implements herita