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.