Closed (fixed)
Project:
Minutes
Version:
4.7.x-1.x-dev
Component:
Code
Priority:
Normal
Category:
Bug report
Assigned:
Reporter:
Created:
13 Sep 2006 at 18:50 UTC
Updated:
9 Oct 2006 at 21:00 UTC
postgresQL does not have a native concat() function so instead drupal defines its own. However since only concat(text, text) is defined by default postgres fails to run the two queries in minutes.module which used 3 and 4 arguments, one workaround I've tried is to simply define these 2 additional functions. A perhaps better options might be to change the code so it does not use this function, anyway the 2 definitions is:
CREATE OR REPLACE FUNCTION "concat"(text, text, text) RETURNS text AS '
SELECT $1 || $2 || $3;
' LANGUAGE 'sql';
and
CREATE OR REPLACE FUNCTION "concat"(text, text, text, text) RETURNS text AS '
SELECT $1 || $2 || $3 || $4;
' LANGUAGE 'sql';
Comments
Comment #1
pukku commentedHi! The use of concat is in a tricky part of the module which will have to be redone at some point. I have, however, gone ahead and fixed this problem so that it will use the proper version of concat (or ||) depending on the database type.
Comment #2
(not verified) commented