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
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 |