| From: | Berend Tober <btober(at)computer(dot)org> |
|---|---|
| To: | Melvin Davidson <melvin6925(at)gmail(dot)com>, Ray Cote <rgacote(at)appropriatesolutions(dot)com> |
| Cc: | pgsql-general General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: PostgreSQL Developer Best Practices |
| Date: | 2015-08-25 00:00:39 |
| Message-ID: | 55DBB027.20505@computer.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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 ?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Melvin Davidson | 2015-08-25 00:22:17 | Re: PostgreSQL Developer Best Practices |
| Previous Message | Florin Andrei | 2015-08-24 18:45:25 | Re: master/master replication with load balancer in front |