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;
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
