Re: [Phpwiki-talk] Type for cached_html for psql-initialise.sql

[AlJeux <al...@fr...>]

Reini Urban a écrit :
> Alain Peyrat schrieb:
>> Hi,
>>
>> I'm working with Marc-Etienne Vargenau, we are running a phpwiki-1.3.14 + cvs
>> installation with a postgresql database.
>>
>> I found some errors while unpacking the cached page. At first glance, this seems
>> to be caused by the fact that the datas are binaries (compressed by gzcompress)
>> but the type is TEXT.
>>
>> In file psql-initialize.sql, the line with the bytea (binary type) has been
>> commented.
>>
>> [...]
>> 	--cached_html  	bytea DEFAULT ''
>> 	cached_html  	TEXT DEFAULT ''
>> [...]
>>
>> Do you remember why ?
> 
> I tried two versions:
> With and without HAVE_BYTEA in the backends.
> 7.x worked fine and 8.x failed with one of these, but I forgot which.
> 
> Looks like ADODB requires bytea:
> 
> lib\WikiDB\backend\ADODB_postgres7.php:
> if (!defined("USE_BYTEA"))     // see schemas/psql-initialize.sql
>      define("USE_BYTEA", true); // only BYTEA is binary safe
> 
> and Pear the opposite:
> 
> lib\WikiDB\backend\PearDB_pgsql.php
> if (!defined("USE_BYTEA")) // see schemas/psql-initialize.sql
>      //define("USE_BYTEA", true);
>      define("USE_BYTEA", false);

Thank you for your very fast answer. I didn't noticed the USE_BYTEA 
define. I will carefully take a look at it and will make some tests to 
find what we need exactly.

Many thanks,
Alain.