Den 2012-03-06 22:08 skrev Thomas Steinmaurer såhär: > > > Den 2012-03-06 21:52 skrev Thomas Steinmaurer såhär: > >> > >> When using a BIGINT feed > >> by a generator, you can set a starting value per site/server and that > >> way, you somehow "know" the source of insertion when merging the > >> satellite databases with a central database. > >> > >> > > > > Sounds risky and error prone... Better add a source column. > > And the source column is feed by what? It can be equally risky if you > forget to correctly setup that value for the particular site/server. > > Just a thought. ;-) >
I don't think so. Missing source info is a lot less harmful than duplicate primary keys, which I believe you run the risk of with the approach you described. Also, it goes against some rather fundamental principles to encode information into primary keys. Down that road your feet tend to start hurting, after a few shots. ;-) Kjell -- -------------------------------------- Kjell Rilbe DataDIA AB E-post: [email protected] Telefon: 08-761 06 55 Mobil: 0733-44 24 64 [Non-text portions of this message have been removed] ------------------------------------ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Visit http://www.firebirdsql.org and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links ! Also search the knowledgebases at http://www.ibphoenix.com ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: [email protected] [email protected] <*> To unsubscribe from this group, send an email to: [email protected] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
