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;