Обсуждение: Problem with Sequences

Hello all,

I am new here...

I have a Problem by one of our Applications.
The Frontend ist an Access-Application who connects through ODBC to the postgres-database (7.3.2).
Two of the three Applications works fine. The other have possibly an Problem with Sequences.
The Problem is the folowing:

On user who works with the Database create an new record and save this.
Here the record becomes an ID and another Number from an two sequences.

One other user ist in this moment working with the database and create an new record, too.
Now he becomes in some circumstances the same ID like the first saved record from the other user with the effect, that
theother record is nolong in the database. 

Is this problem possible?
How the sequences where build (processlist)?
Can an extremly high load of the server (2.0-5.0) can create such Problems?

Thanks for ideas and help...

cu

Markus
--
Markus Espenhain                         Fon:  +49 (7 11) 48 90 83 - 0
ETES - EDV-Systemhaus GbR                Fax:  +49 (7 11) 48 90 83 - 50
Libanonstrasse 58 A * D-70184 Stuttgart  Web: http://www.etes.de

Markus Espenhain <espenhain@etes.de> writes:
> On user who works with the Database create an new record and save this.
> Here the record becomes an ID and another Number from an two sequences.

> One other user ist in this moment working with the database and create an new record, too.
> Now he becomes in some circumstances the same ID like the first saved record from the other user with the effect,
thatthe other record is nolong in the database. 

> Is this problem possible?

Not unless you're failing to use the sequences correctly.  Show us the
SQL queries being issued by each application, please.

            regards, tom lane