Received: from sss.pgh.pa.us (sss.pgh.pa.us [216.151.103.158]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f44MOaA82192; Fri, 4 May 2001 18:24:36 -0400 (EDT) (envelope-from tgl@sss.pgh.pa.us) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.11.3/8.11.3) with ESMTP id f44MOAR01701; Fri, 4 May 2001 18:24:10 -0400 (EDT) To: =?iso-8859-1?q?Mart=EDn=20Marqu=E9s?= cc: pgsql-sql@postgresql.org, pgsql-general@postgresql.org Subject: Re: [SQL] delete with cascade In-reply-to: <01050211140201.25070@bugs> References: <01050211140201.25070@bugs> Comments: In-reply-to =?iso-8859-1?q?Mart=EDn=20Marqu=E9s?= message dated "Wed, 02 May 2001 11:14:02 +0300" Date: Fri, 04 May 2001 18:24:09 -0400 Message-ID: <1698.989015049@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200105/206 X-Sequence-Number: 8941 =?iso-8859-1?q?Mart=EDn=20Marqu=E9s?= 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