| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Markus Espenhain <espenhain(at)etes(dot)de> |
| Cc: | Postgres <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: Problem with Sequences |
| Date: | 2003-09-12 14:16:16 |
| Message-ID: | 10731.1063376176@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Markus Espenhain <espenhain(at)etes(dot)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, that the 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | pginfo | 2003-09-12 14:28:10 | Re: pg 7.3.4 and linux box crash |
| Previous Message | Tom Lane | 2003-09-12 14:00:14 | Re: pg 7.3.4 and linux box crash |