Message-Id: <199909121425.QAA05055@eunet.at>
Date: Sun, 12 Sep 1999 16:25:17 +0200 (MEST)
To: pgsql-interfaces@postgresql.org
Reply-To: theofilu@eunet.at
From: theofilu@eunet.at (Theofilu Andreas)
Subject: ecpg and getting just assigned serial number
MIME-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: 8bit

-----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-----