delete with cascade - Mailing list pgsql-general

From Martín Marqués
Subject delete with cascade
Date
Msg-id 01050211140201.25070@bugs
Whole thread Raw
Responses Re: delete with cascade  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Re: [SQL] delete with cascade  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
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
-----------------------------------------------------------------

pgsql-general by date:

Previous
From: pnews@modulo.org
Date:
Subject: underlying structure: varchar vs. text
Next
From: "Carl Rosenberger"
Date:
Subject: Re: Thread or not threads?