Postgres Pro
Downloads
Home   >   mailing lists

Thread: Getting the sequence from pg to insert nexts data

Getting the sequence from pg to insert nexts data

From
"Rodrigo F. Baroni"
Date:
Hello all,



    I'm doing a application using jdbc to connect with
a remote postgres database.

    One of the tables use a sequence value. My doubt
is about how to get the last value of sequence to put
in my form table index to follow the insert others
values.

    Does anybody have some suggests ?!!


  Thanks .

 Rodrigo F Baroni
Computer Science Bach's Student
 Brazil

_______________________________________________________________________
Yahoo! Mail
Mais espaço, mais segurança e gratuito: caixa postal de 6MB, antivírus, proteção contra spam.
http://br.mail.yahoo.com/

SOLUTION: (was : Getting the sequence from pg to insert nexts data )

From
"Rodrigo F. Baroni"
Date:
   Hello all,

      I got resolv the problem :

>     I'm doing a application using jdbc to connect
> with
> a remote postgres database.
>
>     One of the tables use a sequence value. My doubt
> is about how to get the last value of sequence to
> put
> in my form table index to follow the insert others
> values.
>

      I found at list archive :
-------------------------------------
   "
      First "SELECT nextval('usuario_id_usuario_seq')"
and store that value.
Then, "INSERT INTO USUARIO(nombre, passwd, tipo,
correo)
    VALUES('tania','aaaaa', $id,
'tanitamile@yahoo.com');" where $id is the
value you stored before.

--
[]'s
Daniel Serodio   <------  Thanks Daniel. :)
CheckForte  5582-6016

-----------------------------------


   Thanks for all, anyway.

  Rodrigo F Baroni
 Computer Science Bach's Student
  Brazil


_______________________________________________________________________
Yahoo! Mail
Mais espaço, mais segurança e gratuito: caixa postal de 6MB, antivírus, proteção contra spam.
http://br.mail.yahoo.com/

Re: SOLUTION: (was : Getting the sequence from pg to insert nexts data )

From
Paul Thomas
Date:
On 22/06/2003 10:58 Rodrigo F. Baroni wrote:
>
>    Hello all,
>
>       I got resolv the problem :
>
> >     I'm doing a application using jdbc to connect
> > with
> > a remote postgres database.
> >
> >     One of the tables use a sequence value. My doubt
> > is about how to get the last value of sequence to
> > put
> > in my form table index to follow the insert others
> > values.
> >
>
>       I found at list archive :
> -------------------------------------
>    "
>       First "SELECT nextval('usuario_id_usuario_seq')"
> and store that value.
> Then, "INSERT INTO USUARIO(nombre, passwd, tipo,
> correo)
>     VALUES('tania','aaaaa', $id,
> 'tanitamile@yahoo.com');" where $id is the
> value you stored before.>

That's the way I do it. The other way is to define the column as type
serial and let the database generate the default value:

INSERT INTO USUARIO(nombre, passwd, correo)
VALUES('tania','aaaaa','tanitamile@yahoo.com')
If you need to get the generated key you can do this with SELECT
currval('...') but note that this will only work reliably within the same
tranaction.

HTH


--
Paul Thomas
+------------------------------+---------------------------------------------+
| Thomas Micro Systems Limited | Software Solutions for the Smaller
Business |
| Computer Consultants         |
http://www.thomas-micro-systems-ltd.co.uk   |
+------------------------------+---------------------------------------------+