Trigger/Function Problem

From: kowal(at)nawigator(dot)pl
To: pgsql-general(at)postgresql(dot)org
Subject: Trigger/Function Problem
Date: 2001-02-07 15:02:33
Message-ID: 3A816389.1C823506@nawigator.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2001-02-07 15:26:05 Re: Not using index
Previous Message Crispin Miller 2001-02-07 14:47:09 Not using index