[pgadmin-support] PGAdmin Auto-commits?

2008-10-02 Thread Ryan Daniels
When I run insert statements from the SQL window, the data seems to be commited automatically. Is this the case? I looked through the buttons and menu options of the window, but did not find any choices for commit and rollback. Is there an option somewhere that turns off auto-commit? If it is the

Re: [pgadmin-support] PGAdmin Auto-commits?

2008-10-02 Thread Dave Page
On Thu, Oct 2, 2008 at 1:58 PM, Ryan Daniels <[EMAIL PROTECTED]> wrote: > > When I run insert statements from the SQL window, the data seems to be > commited automatically. Is this the case? I looked through the buttons and > menu options of the window, but did not find any choices for commit and >

Re: [pgadmin-support] PGAdmin Auto-commits?

2008-10-02 Thread Dave Page
On Thu, Oct 2, 2008 at 2:12 PM, Michael Shapiro <[EMAIL PROTECTED]> wrote: > Does the SQL window explicitly start a transaction so that all the stmts in > it are committed (or rolled back) if one of the fails? > Or does each stmt execute in its own transaction? Or does it just submit the > entire t

[pgadmin-support] pgadmin 1.8.4 pgagent schedule issue

2008-10-02 Thread susan . williams
I am experiencing an issue with pgadmin 1.8.4 (Windows). The issue is with the pgagent job scheduler. I am able to create new jobs and steps. However, I am unable to create a new schedule. I am also unable to edit / change a schedule that currently exist. The schedule window informs me that

Re: [pgadmin-support] pgadmin 1.8.4 pgagent schedule issue

2008-10-02 Thread Dave Page
On Thu, Oct 2, 2008 at 4:21 PM, <[EMAIL PROTECTED]> wrote: > > I am experiencing an issue with pgadmin 1.8.4 (Windows). The issue is with > the pgagent job scheduler. I am able to create new jobs and steps. > However, I am unable to create a new schedule. I am also unable to edit / > change a

Re: [pgadmin-support] pgadmin 1.8.4 pgagent schedule issue

2008-10-02 Thread susan . williams
Dave - I added comments; but, it still doesn't recognize the date even though it is there. The date in the start date field is 10/03/08. I tried using the format you used below. When I manually typed in the date 10/03/2008, it removed the visible date from the field. Susan Williams Michelin