View Issue Details Jump to Notes ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0012560CDash(No Category)public2011-11-04 15:292011-11-06 15:40
ReporterJulien Jomier 
Assigned ToJulien Jomier 
PrioritynormalSeveritymajorReproducibilityhave not tried
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
TagsNo tags attached.
Attached Files


Julien Jomier (manager)
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'"

 Issue History
Date Modified Username Field Change
2011-11-04 15:29 Julien Jomier New Issue
2011-11-04 15:29 Julien Jomier Status new => assigned
2011-11-04 15:29 Julien Jomier Assigned To => Julien Jomier
2011-11-06 15:40 Julien Jomier Note Added: 0027734
2011-11-06 15:40 Julien Jomier Status assigned => resolved
2011-11-06 15:40 Julien Jomier Fixed in Version => 2.0
2011-11-06 15:40 Julien Jomier Resolution open => fixed

Copyright © 2000 - 2018 MantisBT Team