Hi,
Let's suppose I have a plpgsql function like:
...
begin alter ... ...; insert ... ...; create ... ...; drop ...; and lot of such commands
inany order...
end;
...
(There is no "perform" keyword.)
Sometimes "ALTER" failes becouse it is already done. Sometimes
"INSERT" failes becouse record already exists. Sometimes "DROP"
failes bacouse object is already dropped by earlier execution of this
function. When any of the command fails function has no effect at all
becouse everything is rolled back.
Is it possible to run this function without rollback effect and just
skip failures? (Server is 8.0.0-rc1.)
If the only way is putting each command in
begin perform command;
exception when others then NULL;
end;
then I'm looking for a text processing tool which can do this
"wrapping" automaticaly. I've too much functions and commands in them,
so hand work is not an option.
Daniel