On 7/4/07, John Gardner <[EMAIL PROTECTED]> wrote:
The above code appears to follow the guidelines, but we're still having
problems with sequences being out of sync on each database backend.
It's not the case that one of the sequences on one backend is being
updated and the other isn't, they ARE both being updated, but have
different values in each.
Any help is appreciated.
Excuse me if it's too obvious, but the sequences have to be in sync to
begin with, by resetting them to the same value for example, if the
previous version of your application desynchronized them.
{call setval('sequenceName', sufficientlyLargeNumber)}
Can you reproduce the condition when starting from an empty database?
Gabor
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia