View Issue Details [ Jump to Notes ] [ Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0008318CDashpublic2008-12-18 16:492009-03-09 13:14
ReporterJulien Jomier 
Assigned ToJulien Jomier 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOSOS Version
Product Version1.2.2 
Target VersionFixed in Version1.4 
Summary0008318: viewUpdate.php with PosgreSQL fails
DescriptionChris Garrett on the mailing list reported a bug in viewUpdate.php when using Postgres. The query is using MySQL specific functions. The simple work around for me was to write/copy the equivalent functions. Maybe you can add them to the install step or something...

CREATE OR REPLACE FUNCTION REVERSE(text) RETURNS TEXT AS
'
DECLARE reversed_string text;
incoming alias for $1;
BEGIN
reversed_string = '''';
for i in reverse char_length(incoming)..1 loop
reversed_string = reversed_string || substring(incoming from i for 1);
end loop;
return reversed_string;
END'
LANGUAGE PLPGSQL;

CREATE OR REPLACE FUNCTION LOCATE(text,text) RETURNS INT AS
'SELECT STRPOS($2, $1)'
LANGUAGE SQL;

CREATE OR REPLACE FUNCTION RIGHT(text,int) RETURNS TEXT AS
'SELECT SUBSTR($1, LENGTH($1)-$2+1)'
LANGUAGE SQL;
TagsNo tags attached.
Attached Files

 Relationships

  Notes
(0015610)
Julien Jomier (manager)
2009-03-09 13:14

 Thanks for the report!

 Issue History
Date Modified Username Field Change
2008-12-18 16:49 Julien Jomier New Issue
2008-12-18 16:49 Julien Jomier Status new => assigned
2008-12-18 16:49 Julien Jomier Assigned To => Julien Jomier
2009-03-09 13:14 Julien Jomier Note Added: 0015610
2009-03-09 13:14 Julien Jomier Status assigned => closed
2009-03-09 13:14 Julien Jomier Resolution open => fixed
2009-03-09 13:14 Julien Jomier Fixed in Version => 1.4

Copyright © 2000 - 2018 MantisBT Team