Re: ON DELETE Behavior after the fact

From: jdassen(at)cistron(dot)nl (J(dot)H(dot)M(dot) Dassen (Ray))
To: pgsql-general(at)postgresql(dot)org
Subject: Re: ON DELETE Behavior after the fact
Date: 2001-04-28 11:28:31
Message-ID: slrn9elaav.j4t.jdassen@odin.cistron-office.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

John Pagakis <John(dot)Pagakis(at)DevelopOnline(dot)com> wrote:
>I have a database in production that requires some ON DELETE behavior. Is
>there a way to use ALTER TABLE to define ON DELETE behavior for the foreign
>keys, or will I have to write triggers at this point?

Have you looked at
http://techdocs.postgresql.org/techdocs/hackingreferentialintegrity.html ?

HTH,
Ray
--
USDoJ/Judge Jackson: "Microsoft has performed an illegal operation and will
be shut down."
James Turinsky in alt.sysadmin.recovery

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Maxim Maletsky 2001-04-28 12:57:55 test
Previous Message Joseph 2001-04-28 10:41:03 readline missing when compiling