[hermes] Postgers database problem (hermes_jobtypes_seq)

[Jason M. Felice]

On Wed, Feb 11, 2004 at 09:40:31PM +0000, Josh Endries wrote:
> Hi all,
> 
> I just installed Hermes in a new CVS installation of Horde, and I'm getting 
> errors from Postgres when I try to add a Job Type. This is what I'm seeing 
> in the log:
> 
> Feb 11 15:14:35 horde postgres[27194]: [4-1] ERROR:  relation 
> "hermes_jobtypes_seq" does not exist
> Feb 11 15:14:35 horde postgres[27194]: [4-2] STATEMENT:  SELECT 
> NEXTVAL('hermes_jobtypes_seq')
> 
> I did a grep through the code (horde/hermes and framework) and didn't see 
> any "jobtypes_seq" in there at all. Nor did I find any references to 
> "nextval", so I'm not sure what to make of this. When I originally set up 
> the tables for Hermes, I merged hermes.sql then 
> update_clientjob_pgsql.sql, hopefully this was the right thing to do. :) 
> It looks like some sort of Postgres problem, has anyone out there ran into 
> this or successfully used pgsql with Hermes?

I use it with PostgreSQL exclusively.   You need to upgrade PEAR's DB
package.

> 
> Thanks,
> Josh
-- 
 Jason M. Felice
 Cronosys, LLC <http://www.cronosys.com/>
 216.221.4600 x302