[ic] IC 5.6.1 + Pg 8.4 = Problem

[Peter]

On 08/24/2009 10:46 AM, Toni Mueller wrote:
> Hi,
> 
> 
> I've just tried to set up the 'standard' shop included with IC 5.6.1 to
> test drive, and found that it does not work:
> 
> 
> 127.0.1.1 mojjh362:127.0.1.1 - [24/August/2009:18:07:35 +0200] standard /cgi/standard Runtime error: DBD::Pg::st execute failed: ERROR:  operator does not exist: character varying <> integer
>> LINE 1: select * from products  WHERE inactive <> 1
>>                                                ^
>> HINT:  No operator matches the given name and argument type(s). You might need to add explicit type casts. at /home/imke/interchange/lib/Vend/Table/DBI.pm line 1910.
> 
> 
> The test box is Debian-Lenny with a backported PostgreSQL (ie, 8.4).

This line should fix it (untested on debian), provided you have sudo:
curl -s
'http://git.icdevgroup.org/?p=interchange.git;a=blob_plain;f=eg/pg83-implicit-casts.sql;hb=HEAD'
| sudo -u postgres psql


Peter