Re: Last inserted id - Mailing list pgsql-odbc

From Dave Page
Subject Re: Last inserted id
Date
Msg-id AA30E7BCCA5C1D4E88A231900F8325C00C72@dogbert.vale-housing.co.uk
Whole thread Raw
In response to Last inserted id  ("Simeo Reig" <simreig@terra.es>)
List pgsql-odbc

> -----Original Message-----
> From: Jean-Michel POURE [mailto:jm.poure@freesurf.fr]
> Sent: 12 November 2001 09:36
> To: pgsql-odbc@postgresql.org
> Subject: Re: [ODBC] Last inserted id
>
>
> Hello,
>
> Why don't you add a timestamp field in the table?
> Insert a value with current time, then query to get the
> corresponding row.

'Cos that's not safe either - you might get multiple rows inserted at the
same time - unlikely, but certainly possible.

/Dave.

pgsql-odbc by date:

Previous
From: Jean-Michel POURE
Date:
Subject: Re: Last inserted id
Next
From: Jean-Michel POURE
Date:
Subject: Re: Last inserted id