from the postgres doco:
SELECT last_value FROM seqname
and you shouldn't have to worry about timing... sequence allocations will
be on a per connection basis, so as long as you're not sharing connections
between threads (you're not are you (o: ..) then you'll be ok.
it is kinda off topic though - the postgres docs are a good read too (o:
cheers
dim
On Tue, 25 Sep 2001, Micael Padraig Og mac Grene wrote:
> Don't know PostgreSQL, but it must be a call of to get something like
> "lastId()". Watch not to leave any space in time between the two, if you
> have an active site, and even if you do not.
>
>
> -----Original Message-----
> From: Lester June Cabrera <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
> Date: Tuesday, September 25, 2001 9:47 PM
> Subject: [JSP] get serial value in PostgreSQL
>
>
> >
> >After adding a record in PostgreSQL with id as serial, how do I get the
> >value of id?
> >
> >
> >Thanks,
> >Lester
> >
> >
>
>