SQL errors with PostGreSQL [#169253]

Following errors after enabling module:

warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "user_activity" does not exist in /opt/csw/apache2/share/htdocs/drupal-5.2/includes/database.pgsql.inc on line 125.
user warning: query: SELECT COUNT(uid) AS count FROM user_activity WHERE uid=1 in /opt/csw/apache2/share/htdocs/drupal-5.2/includes/database.pgsql.inc on line 144.
warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "user_activity" does not exist in /opt/csw/apache2/share/htdocs/drupal-5.2/includes/database.pgsql.inc on line 125.
user warning: query: INSERT INTO user_activity (uid, pis, logins, since) VALUES (1, 1, 1, 1187702674) in /opt/csw/apache2/share/htdocs/drupal-5.2/includes/database.pgsql.inc on line 144.

Patch is attached that creates this table in PostGreSQL:

--- user_activity/user_activity.install Tue Aug 21 15:00:53 2007
+++ user_activity.original/user_activity.install        Mon Jul 16 14:54:40 2007
@@ -15,13 +15,6 @@
       );
       break;
     case 'pgsql':
-      db_query("CREATE TABLE user_activity (
-                  uid int_unsigned NOT NULL PRIMARY KEY,
-                  pis integer NOT NULL,
-                  logins integer NOT NULL,
-                  since integer NOT NULL
-                );"
-      );
       break;
   }
 }
@@ -31,4 +24,4 @@
  */
 function user_activity_uninstall() {
   db_query('DROP TABLE {user_activity}');
-}
+}

Comment	File	Size	Author
#1	user_activity.pgsql_.patch	576 bytes	Brad_Macpherson
	user_activity_pgsql.patch.txt	622 bytes	Brad_Macpherson

Comments

Comment #1

Brad_Macpherson commented 21 August 2007 at 15:58

Status:

Active

» Needs review

Status	File	Size
new	user_activity.pgsql_.patch	576 bytes

Actually, that patch won't work - try this one:

diff -nur user_activity.original/user_activity.install user_activity/user_activity.install
--- user_activity.original/user_activity.install        Mon Jul 16 14:54:40 2007
+++ user_activity/user_activity.install Tue Aug 21 15:00:53 2007
@@ -15,6 +15,13 @@
       );
       break;
     case 'pgsql':
+      db_query("CREATE TABLE user_activity (
+                  uid int_unsigned NOT NULL PRIMARY KEY,
+                  pis integer NOT NULL,
+                  logins integer NOT NULL,
+                  since integer NOT NULL
+                );"
+      );
       break;
   }
 }