Re: Trigger/Function Problem

This sounds like it might be better handled by foreign keys. You can just
add a constraint to mp3user_data:

FOREIGN KEY (id) REFERENCES mp3user (id) ON DELETE CASCADE. That will
automatically delete matching values in mp3user_data when something is
deleted from mp3user.

Greg

----- Original Message -----
From: <kowal(at)nawigator(dot)pl>
To: <pgsql-general(at)postgresql(dot)org>
Sent: Wednesday, February 07, 2001 10:02 AM
Subject: Trigger/Function Problem

> Table "mp3user"
> Attribute | Type | Modifier
> --------------+-------------+---------------------------------------------
-----
>
> id | integer | not null default
> nextval('mp3user_id_seq'::text)
> nick | varchar(20) |
>
> Table "mp3user_data"
> Attribute | Type | Modifier
> ------------+-------------+----------------------
> id | integer | not null
> imie | varchar(30) | not null
> nazwisko | varchar(30) | not null
>
> I have to table looking like the above (only bigger).
>
> What I want to do I to set a trigger which ON DELETE from "mp3user"
> table
> will automatically DELETE a row from "mp3user_data" table.
>
> The index in the mp3user is the same as the id from mp3user_data which
> should be errased. I've tried looking at the helps in the manual by
> about Triggers and Function they kinda suck.
>
> If anyone could solve my problem I would be very, Very grateful.
> If possible mail me at: <a
> href="mailto:kowal(at)nawigator(dot)pl">kowal(at)nawigator(dot)pl</a>
>
> Monsier Kowal
>
>