Re: Trigger/Function Problem

kowal(at)nawigator(dot)pl writes:

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

Looks like you want to use a foreign key. Declare your mp3user_data table
something like this:

CREATE TABLE mp3user_data (
id integer references mp3user on delete cascade,
...
);

See http://www.postgresql.org/users-lounge/docs/7.0/user/sql-createtable.htm
for details.

--
Peter Eisentraut peter_e(at)gmx(dot)net http://yi.org/peter-e/