| From: | CaT <cat(at)zip(dot)com(dot)au> |
|---|---|
| To: | Melvin Davidson <melvin6925(at)gmail(dot)com> |
| Cc: | Berend Tober <btober(at)computer(dot)org>, Ray Cote <rgacote(at)appropriatesolutions(dot)com>, pgsql-general General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: PostgreSQL Developer Best Practices |
| Date: | 2015-08-25 00:39:53 |
| Message-ID: | 20150825003953.GH5128@zip.com.au |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Mon, Aug 24, 2015 at 08:22:17PM -0400, Melvin Davidson wrote:
> On Mon, Aug 24, 2015 at 8:00 PM, Berend Tober <btober(at)computer(dot)org> wrote:
> >> 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 ?
>
> I believe he's talking about triggers.
Huh? Why would you use a trigger when FOREIGN KEY has ON UPDATE CASCADE?
--
"A search of his car uncovered pornography, a homemade sex aid, women's
stockings and a Jack Russell terrier."
- http://www.dailytelegraph.com.au/news/wacky/indeed/story-e6frev20-1111118083480
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Melvin Davidson | 2015-08-25 00:53:43 | Re: PostgreSQL Developer Best Practices |
| Previous Message | Melvin Davidson | 2015-08-25 00:22:17 | Re: PostgreSQL Developer Best Practices |