Re: Last inserted id - Mailing list pgsql-odbc

From Jean-Michel POURE
Subject Re: Last inserted id
Date
Msg-id 4.2.0.58.20011112105924.00a613e0@pop.freesurf.fr
Whole thread Raw
In response to Last inserted id  ("Simeo Reig" <simreig@terra.es>)
Responses Re: Last inserted id  (Simeó Reig <simeo@nil.fut.es>)
List pgsql-odbc
At 09:55 12/11/01 +0000, you wrote:
>'Cos that's not safe either - you might get multiple rows inserted at the
>same time - unlikely, but certainly possible.

In most cases a simple timestamp is enough because you add some other
parameter to you query (ex:company name, or whatever field you inserted).
For example, if you insert values with First_name=Dave, Second_name=Page,
Timestamp=current time and query the resulting row, there is *very little*
chance to get rows from other users.

I guess this is the recommended way (see Access howto).

Cheers,
Jean-Michel

pgsql-odbc by date:

Previous
From: Dave Page
Date:
Subject: Re: Last inserted id
Next
From: Dave Page
Date:
Subject: Re: Last inserted id