On Wed, 17 Jul 2002, Rajesh Kumar Mallah. wrote: > On Tuesday 16 July 2002 21:41, you wrote: > > 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). > > Hi thanks for the reply, > > Is it a bug? or is it expected ,
Well, we're not 100% sure it's correct, but it's the expected behavior unless someone can point to something in SQL99 to make us change it. :) > what if i do not want to fire sperate delete SQLs for the slave > tables ? I'm not sure what you mean by this. ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
