Subject | Re: Unique PK |
---|---|
Author | Michael Vilhelmsen |
Post date | 2004-02-03T12:05:20Z |
to one customer I think the problem was:
Network problems. AFAIK none.
But some of the DB was designed before I came around.
So I have to live with some of the flaws.......
Everything new I do is always with a PK of type INTEGER updated by a
trigger
Thank you anyway......
Michael
>Forced writes are ON.
> a) forced writes were switched off
> b) there were quite often network problems.
Network problems. AFAIK none.
>instead of
> Maybe it would be helpful if you use INTEGER as primary keys
> VARCHARS and let these INTs be assigned by using generator values.are
> (I never was a friend of using a VARHCAR pk; that's what generators
> for - supplying a meaningless unique key)Yes.
But some of the DB was designed before I came around.
So I have to live with some of the flaws.......
Everything new I do is always with a PK of type INTEGER updated by a
trigger
Thank you anyway......
Michael