Large objects in web applications
От | wsheldah@lexmark.com |
---|---|
Тема | Large objects in web applications |
Дата | |
Msg-id | 200106261520.LAA16578@interlock2.lexmark.com обсуждение исходный текст |
Ответы |
Re: Large objects in web applications
Re: Large objects in web applications |
Список | 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
В списке pgsql-general по дате отправления: