Do you have session db and your data db on the same db? If you do, most likely, transaction is started in session open handler. You cannot nest transaction and lo_read/open etc fails. If you have situation like this, create dedicated database for session db. Regards, -- Yasuo Ohgaki "Speedboy" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > I am having trouble with the following function working _with_ > sessions. If I turn off my session checking function it enables you to > download the file flawlessly, if sessions are turned on then Internet > Explorer displays an error: > > Internet Explorer cannot download ...URL > > Internet Explorer was not able to open this Internet site. The requested > site is either unavailable or cannot be found. Please try again later. > > Is there a way I can download large objects from postgresql _with_ > sessions? Thankyou. > > function retrieve_file($id) { > global $dbconn1; > > $result1 = pg_exec ($dbconn1, "select data, file_name from files where > id='$id';"); > $image_oid = pg_result($result1 ,0, 'data'); > $file_name = pg_result($result1 ,0, 'file_name'); > > header ("Content-disposition: filename=\"$file_name\""); > header("Content-type: application/download"); > > pg_exec ($dbconn1, "begin transaction;"); > $image_handle = pg_loopen ($dbconn1, $image_oid, 'r'); > > pg_loreadall ($image_handle); pg_loclose ($image_handle); > pg_exec ($dbconn1, "commit transaction;"); } > } > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
