Index: openacs-4/packages/acs-subsite/acs-subsite.info
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/acs-subsite.info,v
diff -u -r1.17 -r1.18
--- openacs-4/packages/acs-subsite/acs-subsite.info	1 Sep 2001 16:41:44 -0000	1.17
+++ openacs-4/packages/acs-subsite/acs-subsite.info	2 Sep 2001 12:42:25 -0000	1.18
@@ -528,6 +528,7 @@
             <file type="content_page" path="www/register/deleted-user.adp"/>
             <file type="content_page" path="www/register/deleted-user.tcl"/>
             <file type="query_file" path="www/register/deleted-user.xql"/>
+            <file type="query_file" db_type="postgresql" path="www/register/email-confirm-postgresql.xql"/>
             <file type="content_page" path="www/register/email-confirm.adp"/>
             <file type="content_page" path="www/register/email-confirm.tcl"/>
             <file type="query_file" path="www/register/email-confirm.xql"/>
Index: openacs-4/packages/acs-subsite/www/register/email-confirm-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/www/register/Attic/email-confirm-postgresql.xql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/acs-subsite/www/register/email-confirm-postgresql.xql	2 Sep 2001 12:42:25 -0000	1.1
@@ -0,0 +1,20 @@
+<?xml version="1.0"?>
+<queryset>
+   <rdbms><type>postgresql</type><version>7.1</version></rdbms>
+
+<fullquery name="register_email_user_info_get">      
+      <querytext>
+      
+	select c.member_state,
+	       c.email,
+	       c.user_id,
+	       c.email_verified_p
+	  from users u, cc_users c
+	 where u.user_id = c.user_id
+	   and u.oid = :row_id
+
+      </querytext>
+</fullquery>
+
+ 
+</queryset>
Index: openacs-4/packages/acs-subsite/www/register/user-new-2-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/www/register/Attic/user-new-2-postgresql.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/acs-subsite/www/register/user-new-2-postgresql.xql	15 May 2001 16:59:01 -0000	1.1
+++ openacs-4/packages/acs-subsite/www/register/user-new-2-postgresql.xql	2 Sep 2001 12:42:25 -0000	1.2
@@ -5,7 +5,7 @@
 
 <fullquery name="user_new_2_rowid_for_email">      
       <querytext>
-      select rowid from users where user_id = :user_id
+      select oid from users where user_id = :user_id
       </querytext>
 </fullquery>