Problems with large objects

From: Luís Martins <lmar(at)ualg(dot)pt>
To: pgsql-php(at)postgresql(dot)org
Subject: Problems with large objects
Date: 2002-03-13 11:57:00
Message-ID: 3C8F3E8C.E3711262@ualg.pt
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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=(at)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

Browse pgsql-php by date

  From Date Subject
Next Message arun kv 2002-03-13 14:12:20 backup postgres database
Previous Message Jules Alberts 2002-03-13 09:11:56 [newbie] simple browse / edit form in PHP