X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 37325D1D903 for ; Wed, 14 Apr 2004 23:01:16 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 92951-10 for ; Wed, 14 Apr 2004 23:01:18 -0300 (ADT) Received: from biglumber.com (biglumber.com [207.228.252.42]) by svr1.postgresql.org (Postfix) with SMTP id 0F239D1D08B for ; Wed, 14 Apr 2004 23:01:14 -0300 (ADT) Received: (qmail 8164 invoked from network); 15 Apr 2004 02:01:18 -0000 Received: from unknown (HELO localhost) (207.228.252.42) by 0 with SMTP; 15 Apr 2004 02:01:18 -0000 From: "Greg Sabino Mullane" To: pgsql-admin@postgresql.org Subject: Re: sequence value of the record just inserted. X-PGP-Key: 2529 DF6A B8F7 9407 E944 45B4 BC9B 9067 1496 4AC8 X-Request-PGP: http://www.biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 In-Reply-To: Date: Thu, 15 Apr 2004 02:01:18 -0000 X-Mailer: JoyMail 1.47 Message-ID: <4e5c4ed5e8ba92358d5915d003ac8d59@biglumber.com> X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200404/225 X-Sequence-Number: 13198 -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 > Also, in perl DBI, the solutions all require executing at least > 2 sql statements. Nothing wrong with that. > I initially hoped there'd be a way to get the oid or sequence number > at the same time as executing an INSERT (one sql statement), like I > get oid in psql. But I use perl DBI, so am not sure how I can get the > oid into a perl variable. See the documentation for pg_oid_status in DBD::Pg. - -- Greg Sabino Mullane greg@turnstep.com PGP Key: 0x14964AC8 200404142201 -----BEGIN PGP SIGNATURE----- iD8DBQFAfe07vJuQZxSWSsgRAsFgAKCw3NkMiZiwZb5gjxu1Q+Nj9wwkpACcDj1n gxSIKAGNJefZaJCmU6+tpgs= =GLPy -----END PGP SIGNATURE-----