[horde] Where does Ingo maintain the id for the primary key for the ingu_rules table?

Bjørn T Johansen btj at havleik.no
Fri Aug 28 15:30:25 UTC 2009


On Fri, 28 Aug 2009 16:58:52 +0200
Jan Schneider <jan at horde.org> wrote:

> Zitat von Bjørn T Johansen <btj at havleik.no>:
> 
> > I am trying to copy the rows in the ingo_rules table to a new  
> > installation but when I try to create a new rule, the sql insert  
> > fails because of of
> > duplicate key... And that makes sense, cause the id it tries to use  
> > is already used... Where can I update Ingo so that it knows how many  
> > rules it has
> > already created?
> 
> It depends on your database. We use sequences for all incrementing  
> primary keys. If your database doesn't support sequences, the DB  
> package's sequence emulation is used, usually with a table name called  
> ..._seq.
> 
> Jan.
> 

Hmmm... I should have checked the sequences before I asked; I use PostgreSQL mysself also and should have known... :-|
But thx... :)


BTJ


More information about the horde mailing list