attached is a revised avatarapproval.install file. At this very moment I don't have my Postgres box around to test but the table definition and index definition should be ok...will follow up at a later time with testing confirmation.

CommentFileSizeAuthor
avatarapproval.install.patch1.16 KBjaydub

Comments

mikejoconnor’s picture

mikejoconnor commented
Status: Needs review » Active

I should start by saying I've only used postgres once, on linux, and I've never used it on windows. I installed postres for windows, and installed drupal. I received the following errors when I tried to install avatar approval.

If you have any suggestions I'm happy to try them. Otherwise I'll take a look at this in the next couple days.

* warning: pg_query() [function.pg-query]: Query failed: ERROR: syntax error at or near "`" LINE 9: PRIMARY KEY ( `uid`, `md5` ) ^ in C:\www\pg\includes\database.pgsql.inc on line 125.
* user warning: query: CREATE TABLE avatar_approval ( uid INT NOT NULL , md5 CHAR(32) NOT NULL, extension CHAR(4) NOT NULL, timestamp INT NOT NULL, approved SMALLINT NOT NULL, moderator VARCHAR(60) NOT NULL, active SMALLINT NOT NULL, PRIMARY KEY ( `uid`, `md5` ) ) in C:\www\pg\includes\database.pgsql.inc on line 144.
* warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "avatar_approval" does not exist in C:\www\pg\includes\database.pgsql.inc on line 125.
* user warning: query: CREATE INDEX avatar_approval_approved_active_idx ON avatar_approval (approved, active) in C:\www\pg\includes\database.pgsql.inc on line 144.