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. -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
