Re: nextval/dbi question - Mailing list pgsql-novice

From Horst Herb
Subject Re: nextval/dbi question
Date
Msg-id 0108060902553H.02026@munin.gnumed.dhs.org
Whole thread Raw
In response to Re: nextval/dbi question  (harrold@sage.che.pitt.edu)
Responses Re: nextval/dbi question  (harrold@sage.che.pitt.edu)
List pgsql-novice
On Monday 06 August 2001 08:47, harrold@sage.che.pitt.edu wrote:

> i was under the impression that nextval would give what the nextval would
> be. i didnt think it was suppose to increment it. after reading your
> response and someone else's it seems i need to get the next value of the
> key and insert it explicitly is that correct?

Yes. Alternatively, you can let Postgres use nextval implicitly, and call
currval afterwards to get the value of the inserted "nextval"

Horst

pgsql-novice by date:

Previous
From: harrold@sage.che.pitt.edu
Date:
Subject: Re: nextval/dbi question
Next
From: Tom Lane
Date:
Subject: Re: nextval/dbi question