X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id D10E3D1C93F for ; Tue, 29 Jul 2003 18:16:10 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 88651-03 for ; Tue, 29 Jul 2003 15:15:08 -0300 (ADT) Received: from mail1.dr.myx.net (mail1.dr.myx.net [217.10.193.161]) by svr1.postgresql.org (Postfix) with ESMTP id 1DD21D1C965 for ; Tue, 29 Jul 2003 15:16:04 -0300 (ADT) Received: from workstation24 (unknown [81.12.137.146]) by mail1.dr.myx.net (mydomain.myx.net) with ESMTP id 67111300658 for ; Tue, 29 Jul 2003 21:16:03 +0300 (EEST) Message-ID: <031a01c355fd$4f52d020$0600a8c0@fix.ro> From: "Viorel Dragomir" To: Subject: transactions Date: Tue, 29 Jul 2003 21:14:53 +0300 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0317_01C35616.74460140" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1106 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200307/432 X-Sequence-Number: 14546 This is a multi-part message in MIME format. ------=_NextPart_000_0317_01C35616.74460140 Content-Type: text/plain; charset="iso-8859-2" Content-Transfer-Encoding: quoted-printable Is there any known issues regarding transactions. I got something like: begin transaction select function1() select into v1 function2() if v1=3D'ok' then commit else rollback end if To notice that both functions have about 100 lines of code. And both functions uses the same tables but in different modes. function1 deletes && function2 inserts The problem is that my web browser hangs on this query and stays that way a= lot [like 30 minutes -- i forgot about it and after 30 minutes it was stil= l trying to open the result page] I hope tomorrow I'll resolv this and if is primary my fault I just shut up = and say nothing. regards, vioss ------=_NextPart_000_0317_01C35616.74460140 Content-Type: text/html; charset="iso-8859-2" Content-Transfer-Encoding: quoted-printable

Is there any known issues regarding=20 transactions.

I got something like:

begin transaction

select function1()

select into v1 function2()

if v1=3D'ok' then commit else rollback end= =20 if

To notice that both functions have about 1= 00 lines=20 of code.

And both functions uses the same tables bu= t in=20 different modes.

function1 deletes && function2=20 inserts

The problem is that my web browser hangs o= n this=20 query and stays that way a lot [like 30 minutes -- i forgot about it and af= ter=20 30 minutes it was still trying to open the result page]

I hope tomorrow I'll resolv this and if is= primary=20 my fault I just shut up and say nothing.

regards,

vioss

------=_NextPart_000_0317_01C35616.74460140--