Thread: Re: Efficient Insert statement for one record into multiple

Re: Efficient Insert statement for one record into multiple

From
"Albe Laurenz"
Date:
>> This is _bad_.
> No, this works

Oops, indeed.

>> What if somebody did a nextval("primary_A") between the insert into A
>> and the insert into B?
> as long as you use currval then it works as advertised

Sorry, I didn't realize that currval returns the last value retrieved
_in this session_.

YOurs,
Laurenz Albe