Patch to add definitions of tables in postgresql is added for node_template.

Patch is against drupal-5 branch
(HEAD appears to be drupal 4.7)

CommentFileSizeAuthor
node_template.install_0.patch667 bytesShiny

Comments

Shiny’s picture

Shiny commented
Title: postgresql table defs for node_temploate » postgresql table defs for node_template
Shiny’s picture

Shiny commented

Tested on postgresql 8.2, ubuntu 32bit, apache 1.3 and php4.something

aron novak’s picture

aron novak
Primary language Hungarian
Location Hungary, Budapest
commented

I committed the code into the CVS. Thanks for the ready-to-use patch. Can you tell me if the module generally works ok w/ postgresql? So the functionality is okay? I assume you tried out installing the module only and not the module functionality in general.

Shiny’s picture

Shiny commented

initially it looks to all be working

i've enabled it a site with postgresql, and will test it for a week. i'm not sure i've used all the functionality yet.

Shiny’s picture

Shiny commented

on DRUPAL-5 branch
leech_yahoo_terms.module: $vocabularies = db_query('SELECT v.vid, v.name FROM {vocabulary} v WHERE module="taxonomy"');

warning: pg_query(): Query failed: ERROR: column "taxonomy" does not exist at character 58 in /home/brenda/projects/drupal-5.1/includes/database.pgsql.inc on line 125.
user warning: query: SELECT v.vid, v.name FROM blah_vocabulary v WHERE module="taxonomy" in /home/brenda/projects/drupal-5.1/includes/database.pgsql.inc on line 144.

i've looked in the table defs for vocabulary, and there's no taxonomy column in either mysql or postgresql.

db_query("CREATE TABLE {vocabulary} (
vid int unsigned NOT NULL auto_increment,
name varchar(255) NOT NULL default '',
description longtext,
help varchar(255) NOT NULL default '',
relations tinyint unsigned NOT NULL default '0',
hierarchy tinyint unsigned NOT NULL default '0',
multiple tinyint unsigned NOT NULL default '0',
required tinyint unsigned NOT NULL default '0',
tags tinyint unsigned NOT NULL default '0',
module varchar(255) NOT NULL default '',
weight tinyint NOT NULL default '0',
PRIMARY KEY (vid)
) /*!40100 DEFAULT CHARACTER SET UTF8 */ ");