hi create sequence mysequence;
create table foo( id integer default nextval('mysequence'), bla text, wombat integer, foobar date, primary key(id) ); insert into foo (wombat) values (88); now how do i know the id of my newly inserted element? and how can this be done in a completely concurrency safe way? cya erik ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings