Postgresql 8.3.x warnings on improperly escaped blobs

Alex_Tutubalin - October 9, 2008 - 18:32
Project:Drupal
Version:6.5
Component:database system
Category:bug report
Priority:normal
Assigned:Unassigned
Status:needs work
Description

Postgresql 8.3.x requires 'E' prefix before string literals with backslashed escapes (i.e. field = E'\n\r\t' instead of field='\n\r\t')

Without it LOTs of db warnings are produced by caching module.

Attached patch adds this prefix in db_encode_blob() function.

NOTE: this is only an idea. For general use, this code needs to be reworked with PgSQL version checks.

AttachmentSizeStatusTest resultOperations
drupal65-pgsql8x-patch2.diff318 bytesIgnoredNoneNone

#1

emi_bcn - May 20, 2009 - 22:58

Any news on it? Will it be introduced to HEAD?

+Subscribing

 
 

Drupal is a registered trademark of Dries Buytaert.