> Why don't you use a sequence at each site and a "site id" field?
> Then put a unique index on the site id + the sequence. You'd get
> something like
>
> |site_id|trans_id|
> ------------------
> | 46 | 23456 |
>
> Also makes it easier to get "all transactions from site 46". You can
> even set each site's site_id field to the appropriate default, if you
> want, so that you don't have to handle it in your code.
I started out that way, but thought the whole select and update thing
would get messy, like select blah from wah where site_id = 43 and
trans_id = 5345 rather than a single where pkey = 43-5345
Thats realy the only reason I didn't do that. Not realy a goot reason
at that...
--
*
* Rob Brown-Bayliss
*