Re: When the trigger is called my application is awaiting the finish

From: Jasen Betts <jasen(at)xnet(dot)co(dot)nz>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: When the trigger is called my application is awaiting the finish
Date: 2010-12-24 03:07:04
Message-ID: if12oo$sag$1@reversiblemaps.ath.cx
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 2010-12-16, felipe(at)informidia(dot)com(dot)br <felipe(at)informidia(dot)com(dot)br> wrote:
> This is a multi-part message in MIME format.
> --------------080402070005010104020405
> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
> Content-Transfer-Encoding: quoted-printable
>
> Hello,
> I'm having a problem running an update command that invokes a trigger,=20
> the problem is that the function performed takes about 45 minutes to=20
> finish and my application is locked waiting for the finish.
> You know how I can't wait for the end?

If you don't care if the update succeeds or not, just don't do the update.
if you do care you need to wait.

Perhaps there's a way yo make the trigger faster.

--
⚂⚃ 100% natural

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jasen Betts 2010-12-24 03:10:25 Re: Data backup to local duplicate without resetting permissions
Previous Message Alfred 2010-12-24 02:41:30 Stitch Large Panorama