Re: [GENERAL] Sequences question & problem

2005-05-16 Thread Michael Fuhr
On Mon, May 16, 2005 at 12:29:27PM +0200, Lada 'Ray' Lostak wrote: > > I am having small trouble with sequences. I am inserting row into table, > and I need to get value of its 'id' column (sequencen type). As far I know > it have to be done by > > SELECT last_value FORM seq_name > >

Re: [GENERAL] Sequences question & problem

2005-05-16 Thread Lada 'Ray' Lostak
Thank you.. I didn't know about race condition.. Shame on me :) > If you're using PostgreSQL 8.0 or later then you can get the sequence > name with the pg_get_serial_sequence() function: Is there any way how to do that (or add this function) in 7.3.x ? Best regards, Lada 'Ray' Lostak Unreal64 Dev