Received: from Radha.DoCS.UU.SE (root@Radha.DoCS.UU.SE [130.238.9.99]) by hub.org (8.9.3/8.9.3) with SMTP id LAA60742 for ; Tue, 7 Dec 1999 11:53:50 -0500 (EST) (envelope-from e99re41@DoCS.UU.SE) Received: from Panter.DoCS.UU.SE (e99re41@Panter.DoCS.UU.SE [130.238.9.114]) by Radha.DoCS.UU.SE (8.6.12/8.6.12) with ESMTP id RAA02350; Tue, 7 Dec 1999 17:53:47 +0100 Received: from localhost (e99re41@localhost) by Panter.DoCS.UU.SE (8.6.12/8.6.12) with SMTP id RAA03355; Tue, 7 Dec 1999 17:53:43 +0100 X-Authentication-Warning: Panter.DoCS.UU.SE: e99re41 owned process doing -bs Date: Tue, 7 Dec 1999 17:53:40 +0100 (MET) From: Peter Eisentraut Reply-To: Peter Eisentraut To: John C Cusick cc: pgsql-sql@postgreSQL.org Subject: Re: [SQL] Getting last used oid In-Reply-To: <19991207.113118.-748361.0.jcc2@juno.com> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII On Tue, 7 Dec 1999, John C Cusick wrote: > How can I call up the last oid used in an insert statement? I've checked If you are writing in C, you can use the PQoidStatus() function. Similar functions are provided in other language wrappers as well (e.g., Perl). A way to do this in psql is going to be in the next release. -- Peter Eisentraut Sernanders vaeg 10:115 peter_e@gmx.net 75262 Uppsala http://yi.org/peter-e/ Sweden