Rob Brown-Bayliss <rob at ZOOstation.cc> writes: >> So what I am doing is begining a transaction, inserting the data, >> selecting the last_value from the sequence and then commiting the >> transaction. last_value is wrong. currval() will work. See the many prior discussions of sequences in the mailing list archives. regards, tom lane