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!