Postgres Pro
Downloads
Home   >   mailing lists

Re: Cascading deletions does not seem to work inside PL/PGSQL functions. - Mailing list pgsql-sql

From Rajesh Kumar Mallah." (by way of Rajesh Kumar Mallah.
Subject Re: Cascading deletions does not seem to work inside PL/PGSQL functions.
Date
Msg-id 200207181112.34288.mallah@trade-india.com
Whole thread Raw
In response to Cascading deletions does not seem to work inside PL/PGSQL functions.  ("Rajesh Kumar Mallah." <mallah@trade-india.com>)
List pgsql-sql
Tree view 
 > 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 themaster table (M).

I want that the records from the tables (x,y,z ect) automatically get deleted
in the function when i delete the recored in the master (M). so that i do not
have to explicitly delete from each of the tables x,y,z, etc.

actually i want to reinsert the records in the table x,y,z as well as M
with some modification.



sorry for my english.


regds
mallah.

> I'm not sure what you mean by this.

--
Rajesh Kumar Mallah,
Project Manager (Development)
Infocom Network Limited, New Delhi
phone: +91(11)6152172 (221) (L) ,9811255597 (M)

Visit http://www.trade-india.com ,
India's Leading B2B eMarketplace.

pgsql-sql by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: Indexing UNIONs
Next
From: "Rajesh Kumar Mallah."
Date:
Subject: Re: Cascading deletions does not seem to work inside PL/PGSQL functions.