Skip site navigation (1) Skip section navigation (2)

Re: Determin if cascade is being used

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Martin Foster <martin(at)ethereal-realms(dot)org>
Cc: PostgreSQL Novice List <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Determin if cascade is being used
Date: 2005-10-17 19:23:45
Message-ID: 11111.1129577025@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-novice
Martin Foster <martin(at)ethereal-realms(dot)org> writes:
> Now what happens is that every time a work is updated or removed it will 
> make sure that the parent layers and gallery do not use it as a 
> highlight.   Meaning that the trigger upon update/delete of Works will 
> update Layer and Gallery.

Couldn't you do that as an ON DELETE SET NULL foreign key reference,
instead of using a custom trigger?

			regards, tom lane

In response to

Responses

pgsql-novice by date

Next:From: Martin FosterDate: 2005-10-17 19:37:03
Subject: Re: Determin if cascade is being used
Previous:From: Martin FosterDate: 2005-10-17 19:21:25
Subject: Re: Determin if cascade is being used

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group