Large objects in web applications

From: wsheldah(at)lexmark(dot)com
To: pgsql-general(at)postgresql(dot)org
Subject: Large objects in web applications
Date: 2001-06-26 15:18:38
Message-ID: 200106261520.LAA16578@interlock2.lexmark.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

Has there been any substantial change in the way large objects are handled with
the coming of 7.1 and the expanded row size limit? Some old online articles
suggested that would change things, but the current docs seem say I still need
to use functions like lo_import.

Assuming things haven't changed for large objects, it appears that to display an
image, I'll need to:
1. select the image from postgresql, using lo_export() to save it to a uniquely
named temp file (to avoid conflicts with other users).
2. Read/load the temp file and send it out to the browser.
3. Delete the temp file

Is this conceptually correct? Any pointers to good docs or articles on doing
this with perl? I know it's straightforward, but I'd just as soon not reinvent
the same mistakes if I can help it. Thanks,

Wes

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Neil Conway 2001-06-26 15:25:47 Error: "Conversion between UNICODE..."
Previous Message Edwin Grubbs 2001-06-26 15:16:34 timestamp to int