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 |
Jump to:
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.
| Attachment | Size | Status | Test result | Operations |
|---|---|---|---|---|
| drupal65-pgsql8x-patch2.diff | 318 bytes | Ignored | None | None |

#1
Any news on it? Will it be introduced to HEAD?
+Subscribing