Unix Technical Forum

Re: Can't create a batch job in pgagent

This is a discussion on Re: Can't create a batch job in pgagent within the pgsql Interfaces Pgadmin Support forums, part of the PostgreSQL category; --> > -----Original Message----- > From: pgadmin-support-owner@postgresql.org > [mailto gadmin-support-owner@postgresql.org] On Behalf Of > Obe, Regina DND\MIS > Sent: 26 ...


Go Back   Unix Technical Forum > Database Server Software > PostgreSQL > pgsql Interfaces Pgadmin Support

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 04-17-2008, 08:09 PM
Dave Page
 
Posts: n/a
Default Re: Can't create a batch job in pgagent



> -----Original Message-----
> From: pgadmin-support-owner@postgresql.org
> [mailtogadmin-support-owner@postgresql.org] On Behalf Of
> Obe, Regina DND\MIS
> Sent: 26 September 2005 13:40
> To: 'pgadmin-support@postgresql.org'
> Subject: [pgadmin-support] Can't create a batch job in pgagent
>
> I'm using the 9/19/05 build of pgAdmin with PostgreSQL
> 8.1-beta2 and the
> pgagent.sql that comes with pgAdmin that to build the pgagent tables.
>
> When you try to create a batch job, it fails the pga_jobstep_check
> constraint on the pga_jobstep table. It appears that the
> editor is trying
> to stuff a null into the jstdbname field when the constraint
> is requiring an
> empty string.


Thanks for the report - I've committed a fix to SVN for this.

Regards, Dave.

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 05:49 PM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.2.0
www.UnixAdminTalk.com