MantisBT - CDash
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0012560CDash(No Category)public2011-11-04 15:292011-11-06 15:40
ReporterJulien Jomier 
Assigned ToJulien Jomier 
PrioritynormalSeveritymajorReproducibilityhave not tried
StatusresolvedResolutionfixed 
PlatformOSOS Version
Product Version1.8 
Target Version2.0Fixed in Version2.0 
Summary0012560: Support for PgSQL 9.x
DescriptionPgSQL is adding escaping by default making it break when doing addslashes
Steps To Reproduce
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2011-11-04 15:29Julien JomierNew Issue
2011-11-04 15:29Julien JomierStatusnew => assigned
2011-11-04 15:29Julien JomierAssigned To => Julien Jomier
2011-11-06 15:40Julien JomierNote Added: 0027734
2011-11-06 15:40Julien JomierStatusassigned => resolved
2011-11-06 15:40Julien JomierFixed in Version => 2.0
2011-11-06 15:40Julien JomierResolutionopen => fixed

Notes
(0027734)
Julien Jomier   
2011-11-06 15:40   
Should be fixed in 2.0. Main issue is that PgSQL has changed the default type of bytea_output to 'hexa' instead of 'escape'. The trick is to do an alter table at install time. That probably means that when upgrading the database from PgSQL 8 to 9 the SQL query should be triggered:

  "ALTER DATABASE ".$CDASH_DB_NAME." SET bytea_output TO 'escape'"