Problems with large objects - Mailing list pgsql-php

From Luís Martins
Subject Problems with large objects
Date
Msg-id 3C8F3E8C.E3711262@ualg.pt
Whole thread Raw
List pgsql-php
  Hi there, I am having a REAL problem with large objects. I insert them into the database, with no problems, but when it is time of reading (the large object is a PDF file) I have a file with a carriage return at the end, so, I get corrupted data !

  The code I use is this:
 

        $paper_row = pg_Fetch_row($paper, 0);
                @pg_Exec($conn,"begin");
                $image_oid=$paper_row[0];
                $fh=@pg_loopen($conn,$image_oid,"r");
                @pg_loreadall($fh);
                @Pg_loClose ($fh);
                @pg_exec("commit");


  Thanks for your attention.

  Best regards.

--
        Luis Martins
  Eng. Sistemas e Computacao
   Servicos de Informatica
   Universidade do Algarve
 

pgsql-php by date:

Previous
From: "Jules Alberts"
Date:
Subject: [newbie] simple browse / edit form in PHP
Next
From: arun kv
Date:
Subject: backup postgres database