This is a discussion on Can't create a batch job in pgagent within the pgsql Interfaces Pgadmin Support forums, part of the PostgreSQL category; --> 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 ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| 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, Regina ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq |