delete with cascade

From: Martín Marqués <martin(at)bugs(dot)unl(dot)edu(dot)ar>
To: pgsql-sql(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org
Subject: delete with cascade
Date: 2001-05-02 08:14:02
Message-ID: 01050211140201.25070@bugs
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-sql

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(at)unl(dot)edu(dot)ar
Programador, Administrador | Centro de Telematica
Universidad Nacional
del Litoral
-----------------------------------------------------------------

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Feite Brekeveld 2001-05-02 08:30:53 update ... from where id in (..) question
Previous Message Lark 2001-05-02 08:07:32 Re: how to start postgresql server ( or postmaster ) automatically

Browse pgsql-sql by date

  From Date Subject
Next Message Wilkinson Charlie E 2001-05-02 15:11:54 RE: List Concatination [warning]
Previous Message John Coers 2001-05-01 22:05:33 Re: Copy