ecpg and getting just assigned serial number - Mailing list pgsql-interfaces

From theofilu@eunet.at (Theofilu Andreas)
Subject ecpg and getting just assigned serial number
Date
Msg-id 199909121425.QAA05055@eunet.at
Whole thread Raw
Responses Re: [INTERFACES] ecpg and getting just assigned serial number  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: [INTERFACES] ecpg and getting just assigned serial number  (Michael Meskes <meskes@postgresql.org>)
List pgsql-interfaces
-----BEGIN PGP SIGNED MESSAGE-----

Hi to all,

I've written a small application first based on Informix and trying to
implement now support for PostgreSQL. I was mostly successful, but there is
still one problem left.
I'm using 'ecpg' to develop my application, because it's mostly compatible
to Informix's 'esqlc'. However. I have a table with a field of type
'serial'. Now I've no problem to insert any sentences into this table, but
immediately after inserting a new sentence I need the newly assigned number
to the serial field in the table. How can I access this number?
With Informix I got this number in a field of structure 'sqlca'. With
PostgreSQL the same field in this structure exists but contains always 0,
as documented.


- --
Theofilu Andreas
http://members.eunet.at/theofilu
              -------------------------------------------------                          Enjoy the science of Linux!
                 Genieße die Wissenschaft von Linux!              -------------------------------------------------
 

-----BEGIN PGP SIGNATURE-----
Version: 2.6.3i
Charset: latin1

iQCVAwUBN9u302j/BcrYxhjVAQGr3gQAhlFZ6Uka/tfcEdSo85NG9Bzq6n4m70HW
f4lsECCTOm8EMCeKHvtJN7t5IZ6PqHTquwkY3WpZpM8PPALRSHPlBtxJF+fI4RrB
dsQ0g02bwm71XgMNh4VLFYf9gttTOAQjxmA30WONIWoYngQIWr6u+7E6ihjOCdb0
BFPplhR5Vts=
=n75F
-----END PGP SIGNATURE-----


pgsql-interfaces by date:

Previous
From: rodneyr@embratel.com.br
Date:
Subject: Embedded SQL in C
Next
From: Tom Lane
Date:
Subject: Re: [INTERFACES] ecpg and getting just assigned serial number