Ehab Galal wrote: > I created a CMD_UTILITY, which upon being executed by the user should do > the following atomically: > 1- drops a table > 2- deletes from another table all rows with a certain criterion: "DELETE > FROM pg_t1 WHERE att = val" > 3- deletes from a third table all rows with a certain criterion: "DELETE > FROM pg_t2 WHERE att = val" > > I do the first step using ProcessUtility(). How can i do the 2nd/3rd steps? > Any suggestions?
Don't do that. Instead, use performDeletion and register your tuples in the pg_t1 and pg_t2 catalogs in pg_depend (using recordDependencyOn). -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly