Hi,
I already know that transaction is impossible inside a function, but I think I really need a way to counter this
I have a stored procedure in pl/sql that makes about 2 000 000 insert. With the way it works, PostGreSQL il making a unique transaction with all this, resulting so bad performances I can’t wait the procedure to finish
I must find a way to make commit between INSERT.
Thanks in advance,
Célestin
Here is the skeleton of my code :
CREATE OR REPLACE FUNCTION F2(…) AS
$$ DECLARE
…
BEGIN
…
FOR ligne IN …
…
LOOP
NSERT INTO
< place I wish I could put a commit >
END LOOP
…
END $$ LANGUAGE plpgsql;
CREATE OR REPLACE FUNCTION F1(…) AS
$$ DECLARE
BEGIN
FOR all IN …
LOOP
PERFORM F2(…)
< another place I could put my commit >
END LOOP
…
END $$ LANGUAGE plpgsql;
2007 - Maporama International - Outgoing mail scanned by BlackSpider