ok i have understand
many thanks to all!
On 6/27/06, Erik Jones <[EMAIL PROTECTED]> wrote:
nik600 wrote:
> hi
>
> i don't have understand how works inheritance of tables...
>
> if table B inherits from table A
>
> - A and B must share primary keys?
>
> - if i isert record in B the record is rep
Inheritance in postgre means you will have same fields definition
like the inherited table plus its own fields. So if table B is inherit
table A,
table B will have same field definition like A plus table B own
unique field(s).
It wont share primary keys, table B just have primary key in th
nik600 wrote:
hi
i don't have understand how works inheritance of tables...
if table B inherits from table A
- A and B must share primary keys?
- if i isert record in B the record is replaced in A ?
can i avoid this?
i would like to have this scenario:
table A
table B inheridts from A
tab
> i don't have understand how works inheritance of tables...
> if table B inherits from table A
> - A and B must share primary keys?
No, currently there is no unique constraint that will force uniqueness across
parent/child/sibling
tables. Just think of them as being nothing more than seperate
hi
i don't have understand how works inheritance of tables...
if table B inherits from table A
- A and B must share primary keys?
- if i isert record in B the record is replaced in A ?
can i avoid this?
i would like to have this scenario:
table A
table B inheridts from A
table C inheridts
