ecpg and getting just assigned serial number

Поиск
Список
Период
Сортировка
От theofilu@eunet.at (Theofilu Andreas)
Тема ecpg and getting just assigned serial number
Дата
Msg-id 199909121425.QAA05055@eunet.at
обсуждение исходный текст
Ответы 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>)
Список 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 по дате отправления:

Предыдущее
От: rodneyr@embratel.com.br
Дата:
Сообщение: Embedded SQL in C
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [INTERFACES] ecpg and getting just assigned serial number