Re: [GENERAL] Database Best Practices ???

1999-08-30 Thread Oliver Elphick
"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 d

No Subject

1999-08-30 Thread Hub.Org News Admin

Re: [GENERAL] Database Best Practices ???

1999-08-30 Thread amy cheng
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"? 2) "person-address" is the relationship between "

No Subject

1999-08-30 Thread Hub.Org News Admin

[GENERAL] stored procedures

1999-08-30 Thread Matthew Hixson
Could someone point me to a tutorial or HOWTO regarding stored procedures? I know very little about them and need to learn everything I possibly can about them as soon as possible. I looked throught the Postgres docs and couldn't find anything that goes into them in depth. Thank you, -M@

RE: [GENERAL] OID vs SERIAL

1999-08-30 Thread Michael J Davis
Oracle has a rowid column automatically built into every row. Most vendors suggest using primary keys for all tables instead of a "rowid". -Original Message- From: Dirk Lutzebaeck [SMTP:[EMAIL PROTECTED]] Sent: Monday, August 30, 1999 2:15 AM To:

[GENERAL] Re: SERIAL vs. OIDs

1999-08-30 Thread Alke
OIDs Cons: * The code executend in triggers (written in plpgsql) can't know the OID of the inserted/updated/deleted row. This problem make me pass from OIDs to SERIALs, 'cause I need to know an identifier of the row in order to make referential integrity...and I wasn't able to obtain that