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

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!!!!!
>
>
>
>