Re: [SQL] Job control in sql

2012-05-29 Thread Ireneusz Pluta
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 th

Re: [SQL] Job control in sql

2012-05-29 Thread Ireneusz Pluta
W dniu 2012-05-25 10:28, Svenne Krap pisze: Hi. I am building a system, where we have jobs that run at different times (and takes widely different lengths of time). Basically I have a jobs table: create table jobs( id serial, ready boolean, job_begun timestamptz, job_done ti

Re: [SQL] possible bug in psql

2012-05-29 Thread Jasen Betts
On 2012-05-29, chester c young wrote: > do not know if right mailing list > > in psql in Ubuntu, when beginning with a smaller terminal, eg, 80 > col wide, then moving to a larger terminal, eg, 132 col wide, the > readline(?) editor in psql still treats like 80 cols, making it > impossible to edit

Re: [SQL] Job control in sql

2012-05-29 Thread Svenne Krap
On 29-05-2012 12:32, Ireneusz Pluta wrote: > W dniu 2012-05-25 10:28, Svenne Krap pisze: >> Hi. >> >> I am building a system, where we have jobs that run at different >> times (and takes widely different lengths of time). >> >> Basically I have a jobs table: >> >> create table jobs( >> id seri

Re: [SQL] possible bug in psql

2012-05-29 Thread Craig Ringer
On 05/29/2012 07:48 PM, Jasen Betts wrote: On 2012-05-29, chester c young wrote: do not know if right mailing list in psql in Ubuntu, when beginning with a smaller terminal, eg, 80 col wide, then moving to a larger terminal, eg, 132 col wide, the readline(?) editor in psql still treats like 80

Re: [SQL] possible bug in psql

2012-05-29 Thread chester c young
> > do not know if right mailing list > > > > in psql in Ubuntu, when beginning with a smaller > terminal, eg, 80 > > col wide, then moving to a larger terminal, eg, 132 col > wide, the > > readline(?) editor in psql still treats like 80 cols, > making it > > impossible to edit longer text.    >