[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