On 10/5/05, Clark Christensen <[EMAIL PROTECTED]> wrote: > > In my app (a perl/web-based on-line training system), I have a table of > users with an integer primary key column, tech_id. The tech_ids are created > by a foreign system, and either imported with other data, or inserted > as-received by my app. > > In enhancing the app, I'm finding it desirable to insert self-registered > technician candidates in this table with a tech_id that's outside the > sequence of the current tech_id, a temporary tech ID.
Why not just add an auto increment primary key field to this table? Your new primary key field is a 'local' id separate from the tech_id issued by another system.
