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 wrote it all in Lisp!