| From: | Richard Broersma <richard(dot)broersma(at)gmail(dot)com> |
|---|---|
| To: | Greg Stark <stark(at)enterprisedb(dot)com> |
| Cc: | David <wizzardx(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: When to use cascading deletes? |
| Date: | 2009-06-11 14:59:26 |
| Message-ID: | 396486430906110759k5da87756ma20bf33def668bec@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, Jun 11, 2009 at 4:44 AM, Greg Stark<stark(at)enterprisedb(dot)com> wrote:
> I generally leave cascade off except for many-to-many mapping tables
> which contain no additional data and are a pain to manage. Which does
> sound similar to Alban's rule of thumb.
Cascading deletes also make sense for vertically partitioned tables
with a 1 to 1 relationship.
--
Regards,
Richard Broersma Jr.
Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Steven Lembark | 2009-06-11 15:53:12 | Wither 8.3 doc's on cast operator for domain data types? |
| Previous Message | David Fetter | 2009-06-11 14:50:21 | Re: [pgsql-general] Daily digest v1.9081 (14 messages) |