From: | Oliver Elphick <olly(at)lfix(dot)co(dot)uk> |
---|---|
To: | Maurizio Faini <maufaini(at)tiscali(dot)it> |
Cc: | PostgreSQL general list <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: GET LAST ID INSERT |
Date: | 2003-09-24 18:01:08 |
Message-ID: | 1064426468.6612.375.camel@linda.lfix.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(dot)Elphick(at)lfix(dot)co(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Jan Wieck | 2003-09-24 18:05:35 | Re: BSD License |
Previous Message | Nigel J. Andrews | 2003-09-24 17:56:16 | Re: [GENERAL] pgindented tsearch2 for 7.3.4 |