On Tue, 16 Jul 2002, Rajesh Kumar Mallah. wrote:
> Hi folks,
>
> This problem has been troubling me for quite sometime and
> I would be very thankful for your help.
>
> I have included the complete commented script to recreate the problem in
> question.
>
> The problem is inside a plpgsql function i do not see the records in the slave tables
> getting deleted when i delete the corresponing referenced record from the master table.
>
> But things as expected inside a Transaction at the PSQL prompt.
It should get deleted, but it won't be deleted until the end of the
user's sql statement (ie, not until after the function has finished).