Re: object id

Поиск
Список
Период
Сортировка
От maet@gmx.de
Тема Re: object id
Дата
Msg-id 8085.983893250@www36.gmx.net
обсуждение исходный текст
Ответ на Re: object id  (Peter T Mount <peter@retep.org.uk>)
Ответы Re: object id
Список pgsql-interfaces
> Hi,
> 
> I'm using the setBytes() method of jdbc to store a large object to
> database. Now i want to store the object id to another table. Is there
> a
> 
> possibility to get the oid of an object directly after the object is
> stored to store this id into another table.


setBytes() actually stores the large object's OID in that column, so to get
the
oid, simply use getInt() or getString() on the same column.
Only getBytes() & get*Stream() methods (as well as the set* equivalents) 
actually operate on the large object itself. The others would see just the
oid value.

Peter


O.K. but is it possible to get the oid during or directly after inserting
the object into the table without a query to find the column again? I want to
insert an object at the same time into different tables and they should have
the same oid so i can use a join on these tables.

thanks,
Martin

-- 
Sent through GMX FreeMail - http://www.gmx.net



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

Предыдущее
От: Peter T Mount
Дата:
Сообщение: Re: JDBC
Следующее
От: Ken Kline
Дата:
Сообщение: pgaccess and tcl lib