Modify

Ticket #760 (assigned defect)

Opened 3 years ago

Last modified 3 years ago

Autoincrementing primary keys for sqlite3

Reported by: Jonttu Owned by: andrew
Priority: minor Milestone: 1.0
Component: databaseapi Version: 0.7.3
Keywords: sqlite3 autoincrement primary key Cc:

Description

Sqlite3 re-uses primary keys by default. If a row is deleted, the next one will use the same id. This is bad and AFAIK other dbms always increment the primary key by default.

This can be fixed for sqlite3 by explicitely giving the autoincrement keyword for the primary key column.

Attachments

Change History

comment:1 Changed 3 years ago by Jonttu

comment:2 Changed 3 years ago by andrew

  • Status changed from new to assigned
  • Milestone set to 1.0
View

Add a comment

Modify Ticket

Action
as assigned
Author


E-mail address and user name can be saved in the Preferences.

 
Note: See TracTickets for help on using tickets.