"Bradley Russell" <bradley(dot)russell(at)npcinternational(dot)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
In response to
pgsql-novice by date
|Next:||From: Philippe Salama||Date: 2006-12-11 17:24:36|
|Subject: Re: delete cascade question|
|Previous:||From: Bradley Russell||Date: 2006-12-11 16:26:49|
|Subject: delete cascade question|