use nextval('sequence') to allocate uid, pfid, hid, qid, trid etc so that the id is known in advance

I didn't know that 'select nextval("sequence");' would allocate and return
the next value in the sequence, so I've been allowing it to be inserted
into a table automatically when a row is added. That means that I don't
know what it is and in some cases try to select the newly added row to work
out the allocated sequence number.

The process should be
select nextval("sequence) as next_val;
insert into table next_val, other things

Original issue reported on code.google.com by peter.st...@1ab.ltd.uk on 29 Mar 2010 at 9:09

kombat003 / trader-dss

use nextval('sequence') to allocate uid, pfid, hid, qid, trid etc so that the id is known in advance #61