On Thu, Jun 11, 2009 at 4:44 AM, Greg Stark<stark@xxxxxxxxxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general