Re: More plpgsql fun! (deleting large object refs)
От | Robert B. Easter |
---|---|
Тема | Re: More plpgsql fun! (deleting large object refs) |
Дата | |
Msg-id | 0101172305090G.02219@comptechnews обсуждение исходный текст |
Ответ на | More plpgsql fun! (deleting large object refs) (Adam Haberlach <adam@newsnipple.com>) |
Список | pgsql-general |
I did it using a rule before: CREATE RULE image_delete_lo AS ON DELETE TO images DO SELECT lo_unlink(old.image); In PL/pgSQL, you can try using PERFORM: BEGIN PERFORM lo_unlink(OLD.bootstrap_script); PERFORM lo_unlink(OLD.update_archive); END; On Wednesday 17 January 2001 20:06, Adam Haberlach wrote: > Now that I have some magic triggers deleting and updating > rows based on the actions of referring rows, I have to take > care of the deletion of large objects associated with some > rows. Any idea how I should do this? > > > I tried... > BEGIN > SELECT lo_unlink(OLD.bootstrap_script); > SELECT lo_unlink(OLD.update_archive); > END; > > ....this gave "Unexpected SELECT in..." errors. > > I tried... > BEGIN > lo_unlink(OLD.bootstrap_script); > lo_unlink(OLD.update_archive); > END; > > ....this gave parse errors... -- -------- Robert B. Easter reaster@comptechnews.com --------- -- CompTechNews Message Board http://www.comptechnews.com/ -- -- CompTechServ Tech Services http://www.comptechserv.com/ -- ---------- http://www.comptechnews.com/~reaster/ ------------
В списке pgsql-general по дате отправления: