From: Michael Meskes <meskes@postgresql.org>
To: Theofilu Andreas <theofilu@eunet.at>
Cc: pgsql-interfaces@postgresql.org
Subject: Re: [INTERFACES] ecpg and getting just assigned serial number
Date: Mon, 13 Sep 1999 10:27:26 +0200
Message-ID: <19990913102726.B3200@gmx.net> (raw)
In-Reply-To: <199909121425.QAA05055@eunet.at>
References: <199909121425.QAA05055@eunet.at>
On Sun, Sep 12, 1999 at 04:25:17PM +0200, Theofilu Andreas wrote:
> 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.
Where exactly does Informix return it? sqlca[?].
Also does anyone know whether the backend returns that number somewhere?
Michael
--
Michael Meskes | Go SF 49ers!
Th.-Heuss-Str. 61, D-41812 Erkelenz | Go Rhein Fire!
Tel.: (+49) 2431/72651 | Use Debian GNU/Linux!
Email: Michael@Fam-Meskes.De | Use PostgreSQL!
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: meskes@postgresql.org, theofilu@eunet.at
Subject: Re: [INTERFACES] ecpg and getting just assigned serial number
In-Reply-To: <19990913102726.B3200@gmx.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox