Re: On delete cascade!
От | Steve Boyle \(Roselink\) |
---|---|
Тема | Re: On delete cascade! |
Дата | |
Msg-id | 009901c19db8$5d781a60$c55869d5@dualtower обсуждение исходный текст |
Ответ на | On delete cascade! (pocm@rnl.ist.utl.pt (Paulo J. Matos)) |
Список | pgsql-sql |
Is the , after socio the problem here? sb ----- Original Message ----- From: "Roberto Mello" <rmello@cc.usu.edu> To: "Paulo J. Matos" <pocm@rnl.ist.utl.pt> Cc: <pgsql-sql@postgresql.org> Sent: Tuesday, January 15, 2002 6:29 AM Subject: Re: [SQL] On delete cascade! > On Mon, Jan 14, 2002 at 08:31:36PM +0000, Paulo J. Matos wrote: > > 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); > > Ola Paulo, > > You need to take a look at the PostgreSQL documentation as well. Just > reading your college databases book won't cut it most of the time. > > PostgreSQL has excellent documentation, especially the reference manual. > Take a look at it. So far both of your questions could have been answered > by taking a quick glance at the docs. > > http://www.postgresql.org/idocs/ > > -Roberto > > -- > +----| http://fslc.usu.edu/ USU Free Software & GNU/Linux Club |------+ > Roberto Mello - Computer Science, USU - http://www.brasileiro.net/ > http://www.sdl.usu.edu/ - Space Dynamics Lab, Developer > Information is the greatest weapon of power to the modern wizard. > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org) >
В списке pgsql-sql по дате отправления: