Trigger/Function Problem
От | kowal@nawigator.pl |
---|---|
Тема | Trigger/Function Problem |
Дата | |
Msg-id | 3A816389.1C823506@nawigator.pl обсуждение исходный текст |
Ответы |
Re: Trigger/Function Problem
|
Список | 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@nawigator.pl">kowal@nawigator.pl</a> Monsier Kowal
В списке pgsql-general по дате отправления: