On Wed, Jan 5, 2011 at 12:21 PM, Bruce Momjian <bruce@momjian.us> wrote:
> The psql manual page mentions lo_insert:
>
> LASTOID
> The value of the last affected OID, as returned
> --> from an INSERT or lo_insert command. This variable
> is only guaranteed to be valid until after the
> result of the next SQL command has been displayed.
>
> Should that be lo_import? I don't see lo_insert used anywhere. And it
> doesn't seem lo_import sets LASTOID.
I think it's supposed to be lo_import. It sets LASTOID if you do this:
rhaas=# \lo_import '/etc/passwd'
lo_import 16414
rhaas=# select :LASTOID;?column?
---------- 16414
(1 row)
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company