[horde] PostgreSQL errors

[Jan Schneider]

Zitat von "Daniel A. Ramaley" <daniel.ramaley at DRAKE.EDU>:

> On Wednesday 29 March 2006 13:59, Jan Schneider wrote:
>> Zitat von "Daniel A. Ramaley" <daniel.ramaley at DRAKE.EDU>:
>>> Since upgrading to Horde 3.1 i've noticed regular error messages in
>>> PostgreSQL's log:
>>>
>>> Mar 29 12:53:54 sun12 postgres[7205]: [1-1] ERROR:  relation
>>> "horde_histories" does not exist
>>>
>>> Was there something that needed to be done to the database as part
>>> of the upgrade? I noticed that there was an upgrade script in the
>>> Horde 3.1 tarball (horde-3.1/scripts/upgrades/3.0_to_3.1.mysql.sql)
>>> for the MySQL database, but none for PostgreSQL.
>>
>> Because noone contributed one. Patch?
>
> That would explain it. What i've pasted below seems to work; since
> applying it and running "php move_history_out_of_datatree.php" i've
> stopped seeing errors in the log, and Horde still works. You may notice
> a remarkable similarity between what is below and the mysql upgrade
> script; all i did was remove the last line of the mysql script that
> sets permissions as postgresql didn't like the syntax and it didn't
> seem necessary (i applied the below while logged in to postgresql as
> horde).

Great! Committed to CVS, thanks.

Jan.

-- 
Do you need professional PHP or Horde consulting?
http://horde.org/consulting/