Re: Automaticly delete related data

On 25 Nov 2001, Trond Arve Nordheim wrote:

> Hi!
>
> I'm developing a publishing system and are trying to create
> functions/triggers that automaticly wipes out related data to the data
> currently beeing deleted...
>
> For example, I have a table containing site objects (an article or
> whatever) where I have the following fields;
>
> int_objectid SERIAL NOT NULL,
> str_objecttitle VARCHAR(255) NOT NULL,
> ...
> ...
>
> Then, I have a table defining the content of that data;
> int_objectid INT(11) NOT NULL
> str_data TEXT NOT NULL,
> ...
> ...
>
> What I want to do is;
> When I delete a row from the first table, I want all rows with mathing
> int_objectid values in the second table to be deleted.
>
> I've been reading in a couple of online books and the PostgreSQL
> documentation all day without beeing able to make something of this...
>
> Can anyone give me a hint, or point me in the direction of some
> documentation that can help me out?

If you don't mind the other semantics, you can use foreign keys
to handle this for you with the on delete cascade referential action.