Re: [GENERAL] Very big transaction in a stored procedure : how can i commit in the middle of it ?

2007-05-24 Thread Célestin HELLEU
e for !! -Message d'origine- De : Martijn van Oosterhout [mailto:[EMAIL PROTECTED] Envoyé : jeudi 24 mai 2007 16:48 À : Célestin HELLEU Cc : pgsql-general@postgresql.org Objet : Re: [GENERAL] Very big transaction in a stored procedure : how can i commit in the middle of it ? On Thu, May 24, 200

[GENERAL] Very big transaction in a stored procedure : how can i commit in the middle of it ?

2007-05-24 Thread Célestin HELLEU
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 perfor

[GENERAL] Very big transaction in a stored procedure : how can i commit in the middle of it ?

2007-05-24 Thread Célestin HELLEU
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 perfor