Thread: delete with cascade
I was reading the manuals on DELETE and I saw this: By default DELETE will delete tuples in the table specified and all its sub-tables. If you wish to only update the specific table mentioned, you should use the ONLY clause. I just don't understand what sub-tables means. Does it mean that it will delete rows on other tables which are referenced with a FOREIGN KEY to the row which will be deleted? Saludos... :-) -- El mejor sistema operativo es aquel que te da de comer. Cuida tu dieta. ----------------------------------------------------------------- Martin Marques | mmarques@unl.edu.ar Programador, Administrador | Centro de Telematica Universidad Nacional del Litoral -----------------------------------------------------------------
On Wed, 2 May 2001, [iso-8859-1] Mart�n Marqu�s wrote: > I was reading the manuals on DELETE and I saw this: > > By default DELETE will delete tuples in the table specified and all its > sub-tables. If you wish to only update the specific table mentioned, you > should use the ONLY clause. Any table that inherit from this table. > I just don't understand what sub-tables means. Does it mean that it will > delete rows on other tables which are referenced with a FOREIGN KEY to the > row which will be deleted? Only if you defined the foreign key with ON DELETE CASCADE.
=?iso-8859-1?q?Mart=EDn=20Marqu=E9s?= <martin@bugs.unl.edu.ar> writes: > I was reading the manuals on DELETE and I saw this: > By default DELETE will delete tuples in the table specified and all its > sub-tables. If you wish to only update the specific table mentioned, you > should use the ONLY clause. > I just don't understand what sub-tables means. It means inheritance children, ie, tables you created with INHERIT from the specified table. > Does it mean that it will > delete rows on other tables which are referenced with a FOREIGN KEY to the > row which will be deleted? Foreign key deletion is an unrelated feature. regards, tom lane