cascade problems

for those who can help,

on my database i have two tables, organization and transaction, listed here;
-------------------------------------
create table organization(
organ_person_id serial primary key,
asset_id int,
fname text,
lname text,
phone varchar(15),
email varchar(20),
constraint organization_asset_id_fk foreign key(asset_id) references
assets(asset_id));

create table transaction(
transaction_id serial primary key,
trans_date timestamp default current_timestamp,
return_date timestamp,
organ_person_id int,
constraint transaction_organ_person_id_fk foreign key(organ_person_id)
references organization(organ_person_id) on delete cascade );

---------------------------------

what i want is for a delete on transaction to make a delete on
organization where the organ_person_id s match up,with a query like;

*delete from transaction where organ_person_id = 15;*

but this is not happening. all it does is delete from transaction, and
doesn't touch organization. am i doing something wrong?

please help,

mike z

--
Mike Zouroudis
Intern
__________________________________________________
I.D.E.A.L. Technology Corporation - Orlando Office
http://www.idealcorp.com - 407.999.9870 x14