Re: [pgadmin-support] pgagent hangs forever in "r" state

2015-07-20 Thread Sanket Mehta
Hi Dave, I have tried to reproduce the same in my system by resetting the pgagent sequences to 1. Below is the results I have came across: the job is not getting executed and its current status is "i" (no steps found ) although I have specified 2 steps for that job. Below is the log en

[pgadmin-support] PGadmin 1.20.0 / Apple MBP 13 (early 2015) SwissGerman Keyboard [!¨][^`] keys bug

2015-07-20 Thread Erwan Begoc
Hi All, I could not find this bug listed anywhere. With PGadmin 1.20 from binary .dmg file, on a early 2015 13 inch Retina MacBookPro with Swiss german keyboard, I am getting a strange bug where in the SQL editor pane, i am not able to use two keys for characters ^ ` and characters ! ¨ , no output

Re: [pgadmin-support] pgagent hangs forever in "r" state

2015-07-20 Thread Dave Page
Hi On Mon, Jul 20, 2015 at 12:49 PM, Sanket Mehta wrote: > Hi Dave, > > I have tried to reproduce the same in my system by resetting the pgagent > sequences to 1. > > Below is the results I have came across: > > the job is not getting executed and its current status is "i" (no > steps fo

Re: [pgadmin-support] pgagent hangs forever in "r" state

2015-07-20 Thread Josh Berkus
On 07/20/2015 08:01 AM, Dave Page wrote: >> Suggestion to resolve the issue: >> >> get the max value of ID from table before insert query and run the >> sequence till we get the max(ID)+1 and then we execute the insert statement >> with this new value as ID. > > We're not doing that - it'