Received: from postgresql.org.org (webmail.postgresql.org [216.126.85.28]) by postgresql.org (8.11.3/8.11.1) with SMTP id f44JFuA05290 for ; Fri, 4 May 2001 15:15:56 -0400 (EDT) (envelope-from pgsql-general-owner@postgresql.org) Received: from mail1.hub.org (webmail.hub.org [216.126.85.1]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f42HMM501426; Wed, 2 May 2001 13:22:23 -0400 (EDT) (envelope-from martin@bugs.unl.edu.ar) Received: from bugs.unl.edu.ar (bugs.unl.edu.ar [168.96.132.208]) by mail1.hub.org (8.11.3/8.11.1) with ESMTP id f42HMHU01287; Wed, 2 May 2001 13:22:18 -0400 (EDT) (envelope-from martin@bugs.unl.edu.ar) Received: by bugs.unl.edu.ar (Postfix, from userid 1004) id 689192AB33; Wed, 2 May 2001 11:14:03 +0300 (GMT) Content-Type: text/plain; charset="iso-8859-1" From: =?iso-8859-1?q?Mart=EDn=20Marqu=E9s?= To: pgsql-sql@postgresql.org, pgsql-general@postgresql.org Subject: delete with cascade Date: Wed, 2 May 2001 11:14:02 +0300 X-Mailer: KMail [version 1.2] MIME-Version: 1.0 Message-Id: <01050211140201.25070@bugs> Content-Transfer-Encoding: 8bit X-Archive-Number: 200105/193 X-Sequence-Number: 8909 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 -----------------------------------------------------------------