Re-setting the primary key in Firebird embedded databases after deleting records

[Ratslinger]

Yes & No. The referred to Bug is discussing the SDBC connection to a Firebird DB and not the compressed. The concept is basically the same. However, have found this → DDL Enhancements.

Now under the section discussing identity column it states:

 An identity column cannot be altered to become a regular column. The reverse is also true.

[Ratslinger]

Now this doesn’t explain why it can go from Yes to No. The bug also discusses the error which crops up about replacing the column when trying to go from No to Yes. So it appears to be along the same lines.

At this point, adding a comment there regarding Firebird embedded may be the best solution.