SVN Commit by dpage: r4244 - trunk/pgadmin3/xtra/pgagent

[svn(at)pgadmin(dot)org]

Author: dpage
Date: 2005-05-24 14:18:55 +0100 (Tue, 24 May 2005)
New Revision: 4244

Modified:
   trunk/pgadmin3/xtra/pgagent/pgagent.sql
Log:
Make sure a DB name has been specified.

Modified: trunk/pgadmin3/xtra/pgagent/pgagent.sql
===================================================================
--- trunk/pgadmin3/xtra/pgagent/pgagent.sql	2005-05-24 12:49:33 UTC (rev 4243)
+++ trunk/pgadmin3/xtra/pgagent/pgagent.sql	2005-05-24 13:18:55 UTC (rev 4244)
@@ -63,7 +63,7 @@
 jstenabled           bool                 NOT NULL DEFAULT true,
 jstkind              char                 NOT NULL CHECK (jstkind IN ('b', 's')), -- batch, sql
 jstcode              text                 NOT NULL,
-jstdbname            name                 NULL, -- REFERENCES pg_database(datname) ON DELETE CASCADE ON UPDATE RESTRICT,
+jstdbname            name                 NOT NULL DEFAULT '' CHECK ((jstdbname != '' AND jstkind = 's') OR (jstdbname = '' AND jstkind = 'b'))
 jstonerror           char                 NOT NULL CHECK (jstonerror IN ('f', 's', 'i')) DEFAULT 'f', -- fail, success, ignore
 jscnextrun           timestamptz          NULL
 ) WITHOUT OIDS;