| From: | Dave Page <dpage(at)vale-housing(dot)co(dot)uk> |
|---|---|
| To: | "'Jean-Michel POURE'" <jm(dot)poure(at)freesurf(dot)fr>, pgsql-odbc(at)postgresql(dot)org |
| Subject: | Re: Last inserted id |
| Date: | 2001-11-12 09:55:37 |
| Message-ID: | AA30E7BCCA5C1D4E88A231900F8325C00C72@dogbert.vale-housing.co.uk |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-odbc |
> -----Original Message-----
> From: Jean-Michel POURE [mailto:jm(dot)poure(at)freesurf(dot)fr]
> Sent: 12 November 2001 09:36
> To: pgsql-odbc(at)postgresql(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jean-Michel POURE | 2001-11-12 10:06:09 | Re: Last inserted id |
| Previous Message | Jean-Michel POURE | 2001-11-12 09:36:03 | Re: Last inserted id |