From: | "Oliver Elphick" <olly(at)lfix(dot)co(dot)uk> |
---|---|
To: | "amy cheng" <amycq(at)hotmail(dot)com> |
Cc: | pgsql-general(at)postgreSQL(dot)org, ghoffman(at)ucsd(dot)edu |
Subject: | Re: [GENERAL] Database Best Practices ??? |
Date: | 1999-08-31 04:54:27 |
Message-ID: | 199908310454.FAA10103@linda.lfix.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
"amy cheng" wrote:
>Oliver, or/and, Gary, and all other experts,
>
>I studied this design:
>1) inheritance and trigger: since "person" and "person-address" relationship
>
>already has triggers, why "organization" and "individual" still need
>triggers with "person-address"?
I don't think that triggers can be inherited automatically. That is why I
did it that way. The implementation of inheritance still needs a lot of
work in PostgreSQL.
>2) "person-address" is the relationship between "address" and
> "person", why "person" still need to DIRECTLY relate with "address"?
> and, again (similar to question 1) why "organization" and "individual"
>still need?
The refint trigger is to make sure that the address record exists before
the person record is updated; if the relation is new there will not be
anything in person_address yet.
The duplication in organisation and individual is again because
inheritance is not fully and consistently implemented.
>Perhaps those codes are just jokes? ????????????????????
The project is not yet complete, so there may be bugs in it!
--
Vote against SPAM: http://www.politik-digital.de/spam/
========================================
Oliver Elphick Oliver(dot)Elphick(at)lfix(dot)co(dot)uk
Isle of Wight http://www.lfix.co.uk/oliver
PGP key from public servers; key ID 32B8FAA1
========================================
" ...Take heed, and beware of covetousness; for a man's
life consisteth not in the abundance of the things
which he possesseth." Luke 12:15
From | Date | Subject | |
---|---|---|---|
Next Message | amy cheng | 1999-08-31 06:29:02 | Re: [GENERAL] Database Best Practices ??? |
Previous Message | Ing. Arturo de la Torre | 1999-08-31 02:13:17 | (no subject) |