Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id DD932475A01 for ; Wed, 7 Aug 2002 14:41:12 -0400 (EDT) Received: from smtprelay6.dc2.adelphia.net (smtprelay6.dc2.adelphia.net [64.8.50.38]) by postgresql.org (Postfix) with ESMTP id 2E2EE475925 for ; Wed, 7 Aug 2002 14:41:12 -0400 (EDT) Received: from johnbr ([68.67.112.141]) by smtprelay6.dc2.adelphia.net (Netscape Messaging Server 4.15 smtprelay6 Dec 7 2001 09:58:59) with SMTP id H0HL8O03.A8R for ; Wed, 7 Aug 2002 14:41:12 -0400 Message-ID: <00fe01c23e41$ca62bca0$0c05050a@johnbr> Reply-To: "John Brothers" From: "John Brothers" To: Subject: getting oid of an INSERT automatically Date: Wed, 7 Aug 2002 14:39:40 -0400 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_00FB_01C23E20.43001670" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4807.1700 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300 X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200208/149 X-Sequence-Number: 8995 This is a multi-part message in MIME format. ------=_NextPart_000_00FB_01C23E20.43001670 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hello all, In pgplsql, is there any way to get the oid that is returned from an INS= ERT statement, without doing a 'follow-up' SELECT for the oid? failing that, is this possible in jdbc, odbc or DBI? Thanks, jb ------=_NextPart_000_00FB_01C23E20.43001670 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hello all,
 
   In pgplsql, is there any way = to get=20 the oid that is returned from an INSERT statement, without
doing a 'follow-up' SELECT for the=20 oid?
 
   failing that, is this possibl= e in=20 jdbc, odbc or DBI?
 
Thanks,
    jb
 
------=_NextPart_000_00FB_01C23E20.43001670--