Re: Deleting entries from multiple tables - Mailing list pgsql-sql

From manidegr8
Subject Re: Deleting entries from multiple tables
Date
Msg-id 1291111205481-3285832.post@n5.nabble.com
Whole thread Raw
In response to Re: Deleting entries from multiple tables  (Dusan Misic <promisic@gmail.com>)
List pgsql-sql
yes i know about on delete cascade
it automatically delete the child when master is deleted

but the database i m working on is not built in this fashion
tables r built on default rules
so constraints r there

i m jus asking to build a procedure or function
that taking from the user and deletes the child and master records against
that input...
i hav tried it on pgadmin 111
but its not working...

please guide me
-- 
View this message in context:
http://postgresql.1045698.n5.nabble.com/Deleting-entries-from-multiple-tables-tp3285654p3285832.html
Sent from the PostgreSQL - sql mailing list archive at Nabble.com.


pgsql-sql by date:

Previous
From: Florian Weimer
Date:
Subject: Re: Is there a solution for "SELECT OR INSERT"
Next
From: Rob Sargent
Date:
Subject: indexing longish string