-----BEGIN PGP SIGNED MESSAGE-----
> 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-----
-----END PGP SIGNATURE-----
In response to
pgsql-admin by date
|Next:||From: Tom Lane||Date: 2004-04-15 04:21:14|
|Subject: Re: Updgrade from 7.3 to 7.4 |
|Previous:||From: Greg Sabino Mullane||Date: 2004-04-15 01:55:59|
|Subject: Re: sequence value of the record just inserted / DBI|