Vick Khera writes:
> On Tue, Nov 16, 2010 at 12:40 PM, Tom Lane wrote:
>> The system will not normally allow cascade actions to be deferred
>> ... did you manually munge the pg_trigger entries? If you managed
>> to provoke this purely through DDL commands, that would be a bug,
>> and I'd like to
On Tue, Nov 16, 2010 at 12:40 PM, Tom Lane wrote:
> The system will not normally allow cascade actions to be deferred
> ... did you manually munge the pg_trigger entries? If you managed
> to provoke this purely through DDL commands, that would be a bug,
> and I'd like to see how you did it.
>
Ba
Vick Khera writes:
> The code looks basically like this, for each owner_id ($oid) targeted
> for the purge:
> BEGIN;
> SET LOCAL synchronous_commit TO OFF;
> SET CONSTRAINTS ALL DEFERRED;
> foreach table (owner_log, ... user_list, invoices, ... )
> DELETE FROM $table WHERE owner_id=$oid
> UPDA
