Re: Parent Id

On Thu, Oct 09, 2003 at 14:26:21 -0400,
  Gene Vital <genevital@karibe.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.