Re: Getting Sequence Value
"David G. Johnston" <[email protected]>
| Newsgroups | gmane.comp.db.postgresql.novice |
|---|---|
| Message-ID | <CAKFQuwbv00CT2vSi19izdEWPSEgAt8hp7P+i46ov3Jxv0c7S-w@mail.gmail.com> |
On Tuesday, January 22, 2019, JORGE MALDONADO <[email protected]> wrote: > I need to get the sequence value of a table before inserting a new > record, so I am using *currval, *but I am getting an error stating that > "currval is not defined for this session". I tried using *nextval*, but > the sequence skips one value because *nextval* increments by one and also > an additional increment is preformed by the *insert* operation. > > How can I get the next available value avoiding these issues? > > Use nextval but don’t throw the value away but pass it into the INSERT statement. Or rewrite so you perform the auto-increment and maybe use “RETURNING” to obtain the ID after the fact. Dave