Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On 2010-12-16, felipe@xxxxxxxxxxxxxxxxx <felipe@xxxxxxxxxxxxxxxxx> 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

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux