Re: PostgreSQL Developer Best Practices

Melvin Davidson wrote:

9.
 >1) What happens if someone mis-types the account-id?
 >     To correct that, you also need to correct the FK field in the
other dozen tables.
 >2) What happens when your company starts a new project (or buys a
    I would not consider the general use of natural primary keys to be
    best practice.
    Let's assume your account_id field is used as a foreign key in a
    dozen other tables.
    1) What happens if someone mis-types the account-id?
          To correct that, you also need to correct the FK field in the
    other dozen tables.

... ON UPDATE CASCADE ?