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
-----------------------------------------------------------------
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 |
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 |