Re: Job control in sql - Mailing list pgsql-sql

From Ireneusz Pluta
Subject Re: Job control in sql
Date
Msg-id 4FC49E8B.6040006@wp.pl
Whole thread Raw
In response to Re: Job control in sql  (Jan Lentfer <Jan.Lentfer@web.de>)
List 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.


pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: possible bug in psql
Next
From: Ireneusz Pluta
Date:
Subject: Re: Job control in sql