the SQL for creating the postgre table is wrong.. I will post correct code here when i figure it out!

Comments

phayes’s picture

phayes commented 
CREATE TABLE {term_image}
(
   tid integer NOT NULL DEFAULT 0, 
   path varchar(255), 
   PRIMARY KEY (tid), 
   CHECK (tid >= 0)
)
nancydru’s picture

nancydru
she/her/hers
Primary language English
Location Boston
commented
Status: Active » Postponed (maintainer needs more info)

Hmm, this should have been fixed in http://drupal.org/node/101116.

If tid must be >= 0, then why have a default of 0? We eliminated that in MySql.

Charlottas’s picture

Charlottas commented

Happy Easter!

I have got the following problem regarding pgsql: the table term_image is created with the newest taxonomy_image.install from the cvs directory.

Installation went through without a db error. But when I go to the categories and after that to the Category Image Tab I get the following:

Query failed: ERROR: syntax error at or near "WHERE" at character 64 in /var/www/cuk/includes/database.pgsql.inc on line 125.
user warning: query: SELECT i.path, d.name FROM term_image i INNER JOIN term_data d WHERE i.tid = d.tid AND i.tid = 55 in /var/www/cuk/includes/database.pgsql.inc on line 144.

Has anybody else experienced problems with the database.pgsql.inc?

Thank you very much.

nancydru’s picture

nancydru
she/her/hers
Primary language English
Location Boston
commented
Assigned: Unassigned » nancydru

@Charlottas - this is actually a different error than what was reported here. But this should have been fixed already. Which version are you using?

nancydru’s picture

nancydru
she/her/hers
Primary language English
Location Boston
commented
Status: Postponed (maintainer needs more info) » Closed (won't fix)

Whenever someone is willing to help fix this, please re-open the issue.