On Thu, Oct 09, 2003 at 14:26:21 -0400,
Gene Vital <genevital(at)karibe(dot)com> wrote:
> when inserting new records into parent / child tables, what is the best
> recommended way of retrieving the pkey value from the parent table when
> using auto incrementing fields ?
You want to use currval. currval will return the last value obtained
by nextval in the same session, so it is safe to use without any additional
locking.