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). ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
