Re: BLOB problem

I agree with Nigel, and I'll take a guess as to why you experienced this,
Conni. If Postgres was upgraded after PHP 4.3.x was installed and PHP
wasn't recompiled, PHP was working with an outdated Postgres client. When
you downgraded, you're recompile used the new client. You could have gotten
the same result just by recompiling the same version of PHP.

> -----Original Message-----
> From: pgsql-general-owner(at)postgresql(dot)org
> [mailto:pgsql-general-owner(at)postgresql(dot)org]On Behalf Of Nigel J. Andrews
> Sent: Wednesday, February 04, 2004 2:23 AM
> To: Cornelia Boenigk
> Cc: scott.marlowe; Tom Lane; Rens Admiraal; pgsql-general(at)postgresql(dot)org
> Subject: Re: [GENERAL] BLOB problem
>
>
> On Wed, 4 Feb 2004, Cornelia Boenigk wrote:
>
> > Hello
> >
> > > I've encountered a problem with a PostgreSQL database
> >
> > Are you sure that the problem is with PostgreSQL?
> >
> > I was testing pg_lo_import() with PHP 4.3.x and found it buggy. I had
> > the opposite problem: only a few bytes from a large object were stored
> > in the database. Then I downgraded to PHP 4.2 and the same script
> > works well on the same database.
>
> I never had any problems with LOs on a php 4.3.x <--> Postrgresql
> system I was
> working on last year. There must have been something else
> happening that isn't
> attributable to use of LOs.
>
>
> --
> Nigel J. Andrews