gsmd@gmx-topmail.de wrote:
> >Could you provide a complete test case?
> As I've been told, there is no special code, just a usual sequence
> usage. There is no small part of code that can be reproduced.
How do you use tose sequences?
> The situation is that there are 2 applications working with the same
> DB and accessing sequences. Each time application is started the
> sequences are reloaded (without doing this the sequences go crazy,
> e.g. you can get 1000 with 5 being the last value).
What do you mean by reloaded?
> > What's the output of
> > "SELECT * FROM sequence_name"?
> ERROR: relation "sequence_name" does not exist
Of course, you should have replaced "sequence_name" with the name of
your sequence.
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support