On Monday 06 August 2001 08:47, harrold(at)sage(dot)che(dot)pitt(dot)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