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 ?