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

From: "Rajesh Kumar Mallah(dot)" <mallah(at)trade-india(dot)com>(by way of Rajesh Kumar Mallah(dot) <mallah(at)trade-india(dot)com>)
To: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Cascading deletions does not seem to work inside PL/PGSQL functions.
Date: 2002-07-18 05:42:34
Message-ID: 200207181112.34288.mallah@trade-india.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

> 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 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.

Browse pgsql-sql by date

  From Date Subject
Next Message Rajesh Kumar Mallah. 2002-07-18 06:39:48 Re: Cascading deletions does not seem to work inside PL/PGSQL functions.
Previous Message Bruno Wolff III 2002-07-18 02:29:01 Re: Indexing UNIONs