Re: IS it a good practice to use SERIAL as Primary Key?

[John McCawley <nospam@xxxxxxxxxxxx>]

Right, but when you write your script (or whatever) that cleans these 
keys up and does the merge, you're where you started -- arbitrary 
integer keys with no meaning.  If you merge databases where the keys are 
*supposed* to have meaning, you then have to mangle *real* data to make 
them merge.


Ron Johnson wrote:

> OK, let's use a synthetic key on the sales master table.  In fact,
> *both* companies have a synthetic key on their sales master tables.
>
> OMG, conflicting/overlapping synthetic keys!!!!!
>
>
>