Skip site navigation (1) Skip section navigation (2)

Re: sequence value of the record just inserted.

From: "Greg Sabino Mullane" <greg(at)turnstep(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: sequence value of the record just inserted.
Date: 2004-04-15 02:01:18
Message-ID: 4e5c4ed5e8ba92358d5915d003ac8d59@biglumber.com (view raw or flat)
Thread:
Lists: pgsql-admin
-----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(at)turnstep(dot)com
PGP Key: 0x14964AC8 200404142201
 
-----BEGIN PGP SIGNATURE-----
 
iD8DBQFAfe07vJuQZxSWSsgRAsFgAKCw3NkMiZiwZb5gjxu1Q+Nj9wwkpACcDj1n
gxSIKAGNJefZaJCmU6+tpgs=
=GLPy
-----END PGP SIGNATURE-----



In response to

pgsql-admin by date

Next:From: Tom LaneDate: 2004-04-15 04:21:14
Subject: Re: Updgrade from 7.3 to 7.4
Previous:From: Greg Sabino MullaneDate: 2004-04-15 01:55:59
Subject: Re: sequence value of the record just inserted / DBI

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group