Re: Job control in sql

From: Ireneusz Pluta <ipluta(at)wp(dot)pl>
To: Jan Lentfer <Jan(dot)Lentfer(at)web(dot)de>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Job control in sql
Date: 2012-05-29 10:01:47
Message-ID: 4FC49E8B.6040006@wp.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

W dniu 2012-05-25 14:52, Jan Lentfer pisze:
> Add a sort of status table where you insert your unique job identifer at the start of the function
> and remove it in the end? As seperate transactions of course.

That might leave status set on forever in a case when a job crashes and does not reach the point
where it removes the identifier.

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Ireneusz Pluta 2012-05-29 10:32:16 Re: Job control in sql
Previous Message Tom Lane 2012-05-29 03:34:14 Re: possible bug in psql