Re: sequence value of the record just inserted.

Поиск
Список
Период
Сортировка
От Greg Sabino Mullane
Тема Re: sequence value of the record just inserted.
Дата
Msg-id 4e5c4ed5e8ba92358d5915d003ac8d59@biglumber.com
обсуждение исходный текст
Ответ на Re: sequence value of the record just inserted.  (Ben Kim <bkim@coe.tamu.edu>)
Список 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@turnstep.com
PGP Key: 0x14964AC8 200404142201

-----BEGIN PGP SIGNATURE-----

iD8DBQFAfe07vJuQZxSWSsgRAsFgAKCw3NkMiZiwZb5gjxu1Q+Nj9wwkpACcDj1n
gxSIKAGNJefZaJCmU6+tpgs=
=GLPy
-----END PGP SIGNATURE-----



В списке pgsql-admin по дате отправления:

Предыдущее
От: "Greg Sabino Mullane"
Дата:
Сообщение: Re: sequence value of the record just inserted / DBI
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Updgrade from 7.3 to 7.4