Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: [GENERAL] Database Best Practices ???
- From: "amy cheng" <amycq(at)hotmail(dot)com>
- To: olly(at)lfix(dot)co(dot)uk
- Cc: pgsql-general(at)postgreSQL(dot)org
- Subject: Re: [GENERAL] Database Best Practices ???
- Date: Tue, 31 Aug 1999 06:29:02 PDT
- Message-id: <19990831132903.45640.qmail@hotmail.com> <text/plain>
"Oliver Elphick" wrote:
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.
thanks for the info.
I still do not understand. IMHO, "person" should not contain address at all --because of "person-address".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 project is not yet complete, so there may be bugs in it!
you defend yourself well, except the "person" one ;-) amy ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com
- Follow-Ups:
- Re: [GENERAL] Database Best Practices ???
- From: Oliver Elphick
- Re: [GENERAL] Database Best Practices ???
- Prev by Date: Re: [GENERAL] Prog to generate table structure ...
- Next by Date: Re: [GENERAL] Referential integrity
- Previous by thread: Re: [GENERAL] Database Best Practices ???
- Next by thread: Re: [GENERAL] Database Best Practices ???
- Indexes: