--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@t...>
wrote:

> Have you considered using a single-column GUID? Totally random and

unique.

Yes, I have. The problem is, that indices are limited concerning the
length of values. In my db I have many tables which describe m:n
relations and firebird doesn't allow me to add a unique index over
two foreign keys, then.
So I think I will go back to the compound PK idea.
Or don't you mind if you can't create an unique index for such a
case.
Remember, compound primary keys are not possible, either.

> You might like to read Dalton Calford's papers on the topic of
> coodinating keys across database boundaries:
>
> http://firebirdsql.org/index.php?op=useful&id=calford_1

I will read this.

Reagrds

Jürgen