Thread: Re: [GENERAL] Database Best Practices ???

Re: [GENERAL] Database Best Practices ???

From
"amy cheng"
Date:
"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.

>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.
I still do not understand. IMHO, "person" should not contain address at all
--because of "person-address".

>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

Re: [GENERAL] Database Best Practices ???

From
"Oliver Elphick"
Date:
"amy cheng" wrote:
  >>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.
  >I still do not understand. IMHO, "person" should not contain address at all
  >--because of "person-address".
  >
  >>The project is not yet complete, so there may be bugs in it!
  >you defend yourself well, except the "person" one ;-)

I suspect you may be right on that; this was only an extract from a much
larger work, so I haven't got round to reviewing it recently.

--
      Vote against SPAM: http://www.politik-digital.de/spam/
                 ========================================
Oliver Elphick                                Oliver.Elphick@lfix.co.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