[<jrogelstad@us...>]

Revision: 14186
          http://postbooks.svn.sourceforge.net/postbooks/?rev=14186&view=rev
Author:   jrogelstad
Date:     2012-10-21 15:17:00 +0000 (Sun, 21 Oct 2012)
Log Message:
-----------
issue #18635: Validate off usr view instead of catalog so mobile client users can also be taken into account.

Modified Paths:
--------------
    xtupleserver/trunk/dbscripts/triggers/crmacct.sql

Modified: xtupleserver/trunk/dbscripts/triggers/crmacct.sql
===================================================================
--- xtupleserver/trunk/dbscripts/triggers/crmacct.sql	2012-10-17 20:06:28 UTC (rev 14185)
+++ xtupleserver/trunk/dbscripts/triggers/crmacct.sql	2012-10-21 15:17:00 UTC (rev 14186)
@@ -172,9 +172,9 @@
 
     -- cannot have fkey references to system catalogs so enforce them here
     IF (NEW.crmacct_usr_username IS NOT NULL) THEN
-      IF (NOT EXISTS(SELECT usename
-                       FROM pg_user
-                      WHERE usename=NEW.crmacct_usr_username)) THEN
+      IF (NOT EXISTS(SELECT usr_username
+                       FROM usr
+                      WHERE usr_username=NEW.crmacct_usr_username)) THEN
         RAISE EXCEPTION 'User % does not exist so this CRM Account Number is invalid.',
                         NEW.crmacct_usr_username;
       END IF;

This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.