Re: [SQL] Cascading deletions does not seem to work inside PL/PGSQL functions.

2002-07-17 Thread Rajesh Kumar Mallah.
Thanks for your reply. Stephan. On Thursday 18 July 2002 12:01, you wrote: > On Thu, 18 Jul 2002, Rajesh Kumar Mallah. wrote: > > > what if i do not want to fire sperate delete SQLs for the slave > > > > > > > tables ? > > > > Hi , > > > > what is mean is that I a have many tables(x,y,z...) w

Re: [SQL] Cascading deletions does not seem to work inside PL/PGSQL functions.

2002-07-17 Thread Rajesh Kumar Mallah.
> what if i do not want to fire sperate delete SQLs for the slave > > > tables ? Hi , what is mean is that I a have many tables(x,y,z...) which reference the master table (M). I want that the records from the tables (x,y,z ect) automatically get deleted in the function when i delete the rec

Re: [SQL] Cascading deletions does not seem to work inside PL/PGSQL

2002-07-17 Thread Stephan Szabo
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

Re: [SQL] Cascading deletions does not seem to work inside PL/PGSQL functions.

2002-07-16 Thread Rajesh Kumar Mallah.
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

Re: [SQL] Cascading deletions does not seem to work inside PL/PGSQL

2002-07-16 Thread Stephan Szabo
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 functio

[SQL] Cascading deletions does not seem to work inside PL/PGSQL functions.

2002-07-16 Thread Rajesh Kumar Mallah.
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