> Does it work any better if you reduce your PK to just PCAT_UNIQUE_REF (the
> generator should assure its uniqueness)?
> Set

>I haven't tried but I would be loathe to drop the primary key to just
>PCAT_UNIQUE_REF. The application supports replication and the
>benefit of PCAT_SYSTEM_REF as part of the primary key is integrity
>within both the application and any external processes that write to
>the database (replication, SQL etc etc).

OK, that's understandable - and from your explanation it even sounds
sensible. But try making a small test (database and program) and see if you
can reproduce your problem. Then see if it helps any to change the primary
key of the test. If so, then this is your problem and you should send your
test to Jason. He is normally quick to fix errors once they're isolated
(but one week from now he will be away in Holland). If the problem persists
even with only one generated field as the primary key - we'll need more
information (or you'll have to repeat your original question to get
Helens/Geoffs attention) to dig deeper.

Set