inproper BLOBs handing

flagging as db issue - sammys?

I'm no expert, and I don't have a Postgres installation to test this, but I think the problem is in /includes/cache.inc

<?php
 function cache_set($cid, $table = 'cache', $data, $expire = CACHE_PERMANENT, $headers = NULL) {
  db_lock_table($table);
  db_query("UPDATE {%s} SET data = '%s', created = %d, expire = %d, headers = '%s' WHERE cid = '%s'", $table, $data, time(), $expire, $headers, $cid);
  ...
?>

fills the bytea-field 'data' with a string.

I think we should add $data = db_encode_blob($data); before we do the update.
In cache_get we do a $cache->data = db_decode_blob($cache->data);

The db_encode_blob might have gone lost when cache.inc was moved out of bootstrap.inc (for a while %b was used)

Attached you can find the patch that add this line
(CAUTION: I did not test this)

Same problem here http://drupal.org/node/92503

@doq: you are right: %b is better.

I addded a patch but as I understand from http://drupal.org/node/92503 , this might not be a complete solution ? Is this issue a duplicate from 92503 ?
(caution: Since I don't have Postgres, I couldn't test the patch)

I agree patch is good. I have tried patch second time - patch is god and working. But now is here new problem - with negative value which is return from function timer_read('page') in function statistics_init() (in statistics.module).

Without patch caching don't work but there is no error like this 'read_timer' - with patch caching working perfect, but there is now problem with statistics.module. If i disable this module all seems working ok.

(havran has created a new issue for the timer_read problem: http://drupal.org/node/93491 )

Patch cache_set_pgsql_error_1.patch.txt works ok on PostgreSQL. RTBC!

Committed to HEAD.