Bug#499765: Serendipity / PostgreSQL issues

2008-10-16 Thread Adrian von Bidder
Yodel! A quick hack to address the (currently, with referrer tracking disabled) most frequent problem is to define in postgres: create function s9yvbi_lt_vi(varchar, integer) returns boolean as $$ select ($1)::integer $2 $$ language sql; create operator ( leftarg = varchar, rightarg =

Bug#499765: Serendipity PostgreSQL issues

2008-09-21 Thread Adrian von Bidder
Package: serendipity Version: 1.3.1-1 Severity: important Hi, Using serendipity with PostgreSQL 8.3.3-1 and php5-pgsql 5.2.6-3 gives me the following errors: Sep 19 18:05:34 zbasel postgres[19689]: [5-1] ERROR: duplicate key value violates unique constraint s9y_referrers_pkey Sep 19