PostgreSQL support
jaydub - October 23, 2007 - 06:52
| Project: | Avatar Approval |
| Version: | 5.x-1.0 |
| Component: | Code |
| Category: | feature request |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | active |
Jump to:
Description
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.
| Attachment | Size |
|---|---|
| avatarapproval.install.patch | 1.16 KB |
#1
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.