Skip site navigation (1) Skip section navigation (2)

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

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 (view raw or flat)
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;


pgadmin-hackers by date

Next:From: svnDate: 2005-05-24 14:21:56
Subject: SVN Commit by dpage: r4245 - in trunk/pgadmin3: src/agent xtra/pgagent xtra/pgagent/include
Previous:From: Dave PageDate: 2005-05-24 12:55:10
Subject: Re: 1.2.2 testing ==> [PROBLEM]

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group