Re: GET LAST ID INSERT

On Wed, 2003-09-24 at 11:49, Maurizio Faini wrote:
> I tried to use CURRVAL, but it gives me this error:
> IS NOT YET DEFINED IN THIS SECTION

That indicates that in the  current session you haven't yet used
nextval() on the id specified in the currval() call.

> this is what i do:
> 1) INSERT (id,....) VALUES (nextval('...id_seq'),.....etc...
> 2) SELECT currval('...id_seq');
> and now there is error.
> 3) get rs
> 4) another insert query with rs current val
>
> why this not work?
> where i make a mistake?

I can't see what is wrong here.  Please post a transcript of the actual
session; your editing has wiped out whatever you did wrong.

--
Oliver Elphick                                Oliver.Elphick@lfix.co.uk
Isle of Wight, UK                             http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839  932A 614D 4C34 3E1D 0C1C
                 ========================================
     "And we know that all things work together for good to
      them that love God, to them who are the called
      according to his purpose."
                                   Romans 8:28