add postgres support
rkofler - October 31, 2007 - 21:07
| Project: | Menu Translation |
| Version: | 5.x-1.x-dev |
| Component: | Code |
| Category: | task |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | active |
Jump to:
Description
maybe I did something wrong, but I had to create the table in postgres manually.
the SQL is analogous the mysqli-section from "menutranslation.install"
CREATE TABLE menutranslation
(
mid int4 NOT NULL,
lang varchar(12) NOT NULL,
title varchar(256) NOT NULL,
CONSTRAINT menutranslation_pkey PRIMARY KEY (mid, lang)
);
#1
for postgres users:
create table manually to prevent this ERROR:
--
# warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "menutranslation" does not exist in /var/apache2_jail/var/www/drupal-5.3/includes/database.pgsql.inc on line 125.
# user warning: query: SELECT title FROM menutranslation WHERE mid = '0' AND lang = 'en' in /var/apache2_jail/var/www/drupal-5.3/includes/database.pgsql.inc on line 144.
...
...
#2
Thanks!
I've added this to the .install file.
I don't use postgresql myself, so i had no idea of the proper SQL code...