Re: Deleting entries from multiple tables

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.