On Monday 03 September 2007 16:24, Marcus Rueckert wrote: Hi,
SQLite3::SQLException: index role_id already exists: CREATE INDEX "role_id" ON roles_static_permissions ("role_id")
(See full trace by running task with --trace)
What's wrong?
afaik sqlite only supports one index per table.
From www.sqlite.org/lang_createindex.html: "There are no arbitrary limits on the number of indices that can be attached to a single table, nor on the number of columns in an index." However, there is already a index with name role_id for table groups_roles. Maybe the names of the indices per database have to be unique? Hmm, that would be strange... regards, Klaas -- Klaas Freitag Architect OPS/IPD SUSE LINUX Products GmbH - Nuernberg --------------------------------------------------------------------- To unsubscribe, e-mail: opensuse-buildservice+unsubscribe@opensuse.org For additional commands, e-mail: opensuse-buildservice+help@opensuse.org