Re: sequences problem

gsmd(at)gmx-topmail(dot)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