From: | svn(at)pgadmin(dot)org |
---|---|
To: | pgadmin-hackers(at)postgresql(dot)org |
Subject: | SVN Commit by dpage: r4244 - trunk/pgadmin3/xtra/pgagent |
Date: | 2005-05-24 13:18:56 |
Message-ID: | 200505241318.j4ODIuGB005453@developer.pgadmin.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-hackers |
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;
From | Date | Subject | |
---|---|---|---|
Next Message | svn | 2005-05-24 14:21:56 | SVN Commit by dpage: r4245 - in trunk/pgadmin3: src/agent xtra/pgagent xtra/pgagent/include |
Previous Message | Dave Page | 2005-05-24 12:55:10 | Re: 1.2.2 testing ==> [PROBLEM] |