<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body>
<p>
<div>
<b><a class="bz_bug_link
bz_status_NEW "
title="NEW - FIREBIRD : Migration : import of table with autoincrement leads to integrity violation when attempting to add new record"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=116982#c4">Comment # 4</a>
on <a class="bz_bug_link
bz_status_NEW "
title="NEW - FIREBIRD : Migration : import of table with autoincrement leads to integrity violation when attempting to add new record"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=116982">bug 116982</a>
from <span class="vcard"><a class="email" href="mailto:robert@familiegrosskopf.de" title="robert@familiegrosskopf.de">robert@familiegrosskopf.de</a>
</span></b>
<pre>Have tested the following:
Opened a migrated Firebird database.
Tried to input a new row in a table with autoincrement.
Next value has to be 10.
When I want to go to next row it shows
*Problematic key value is ("id" = 0)
Click "OK"
then again
*Problematic key value is ("id" = 1)
Click "OK"
... and so on.
The generated key-value will switch every time I try to input the row again up
to the value which works.
Don't know if there is another way to set the start-value of autoincrement.
There isn't a function like
ALTER TABLE "tablename" ALTER COLUMN "fieldname" RESTART WITH <new value>;
available, because the autoincement value is set by a generator. I don't know
where to get the name of the generator. The name isn't shown in the error-code.
Could be with the name this will work:
SET GENERATOR gen_t1_id TO <new value>;</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>