On delete cascade!

Hi all,

On weak entities I've used ON DELETE CASCADE as mentioned in
"Databases Management Systems" by Raghu Ramakrishnan. But I get:
psql:tables.sql:43: ERROR:  parser: parse error at or near "ON"    

on tables like the following:

CREATE TABLE socio_ilumindado (cognome varchar,id integer,nome varchar,alcunha varchar,data_filiacao date,PRIMARY
KEY(id),   FOREIGN KEY(id, nome, alcunha, data_filiacao) REFERENCES socio,ON DELETE CASCADE);
 


How can I change this to be compatible with postgresql?

TIA,
Best regards,

-- 
Paulo J. Matos : pocm(_at_)rnl.ist.utl.pt
Instituto Superior Tecnico - Lisbon    
Software & Computer Engineering - A.I.- > http://www.rnl.ist.utl.pt/~pocm ---    Yes, God had a deadline...    So, He
wroteit all in Lisp!