Re: delete cascade question - Mailing list pgsql-novice

From Tom Lane
Subject Re: delete cascade question
Date
Msg-id 13123.1165854644@sss.pgh.pa.us
Whole thread Raw
In response to delete cascade question  ("Bradley Russell" <bradley.russell@npcinternational.com>)
List pgsql-novice
"Bradley Russell" <bradley.russell@npcinternational.com> writes:
> I'm using libpq and the PQexec function.  I am trying to figure out if I
> execute a delete query on a table that has dependent tables with on
> delete cascade set. Will the result return before or after the cascade
> is finished?

After, unless you have the constraint set to "deferred", in which case
the cascade happens at COMMIT.

            regards, tom lane

pgsql-novice by date:

Previous
From: "Bradley Russell"
Date:
Subject: delete cascade question
Next
From: "Philippe Salama"
Date:
Subject: Re: delete cascade question