vishal saberwal <[EMAIL PROTECTED]> writes:
> So are you suggesting, I need to send the Large object ID to the client?
> Since the application is time critical, is there a way to skip one of the
> two steps (querying once for LOID and then again for its data) to a one step
> by sending the Object
So are you suggesting, I need to send the Large object ID to the client?
Since the application is time critical, is there a way to skip one of
the two steps (querying once for LOID and then again for its data) to a
one step by sending the Object data in the first call?
Are there any examples or ps
thanks for all your responses,
really appreciate it,
I am sorry but I am not as familiar with this as much as you are.
So are you suggesting, I need to send the Large object ID to the client?
Since the application is time critical, is there a way to skip one of
the two steps (querying once for L
On 12/4/2005 11:45 PM, Joshua D. Drake wrote:
Well as I said it depends on the size of the data. Are we talking 100
meg vector images? Then large objects. Are we talking thumbnails that
are 32k then bytea.
I'd say that anything up to a megabyte or so can easily live in bytea.
Beyond that it
This doesn't answer the question.
Fact is that most procedural languages (including PL/pgSQL) don't have
any access to classic large objects in the first place. So all the
stored procedure can do is to return the identifier of the large
object to the client and the client must then use lo_ope
On 12/4/2005 9:24 PM, Joshua D. Drake wrote:
(1) what would be the return type if i want to return a large object (
XYZ.gif) to the remote client (GUI) using stored procedure.
Can anyone give an example please?
Are there any size limitations i need to consider when returning Large
Object using
(1) what would be the return type if i want to return a large object (
XYZ.gif) to the remote client (GUI) using stored procedure.
Can anyone give an example please?
Are there any size limitations i need to consider when returning Large
Object using procedures?
You have to use a lookup table th
On 12/4/2005 7:55 PM, vishal saberwal wrote:
hi,
We are storing the Icons/IMages in the database as Large Objects using
lo_import functions.
(1) what would be the return type if i want to return a large object (
XYZ.gif) to the remote client (GUI) using stored procedure.
Can anyone give an exa
hi,
We are storing the Icons/IMages in the database as Large Objects using lo_import functions.
(1) what would be the return type if i want to return a large object
(XYZ.gif) to the remote client (GUI) using stored procedure.
Can anyone give an example please?
Are there any size limitations i ne
