RE: [HACKERS] TR: Problems with Large Objects !! - Mailing list pgsql-hackers

From Marc G. Fournier
Subject RE: [HACKERS] TR: Problems with Large Objects !!
Date
Msg-id 9ad80f4c23755d740c7f335a1d318b4f
Whole thread Raw
In response to [HACKERS] TR: Problems with Large Objects !!  (ycourties@internet.ubisoft.fr (Yann Courties))
List pgsql-hackers
On Fri, 20 Jun 1997, Yann Courties wrote:

> Hi,
>
> 5.1 is just what's in my PG_VERSION file ?

    Ah, okay, anyone know what version that was?  Or did that include
everything from v1.01 to v1.09? :(

>
> -Yann-
>
> ----------
> De :     Marc G. Fournier[SMTP:scrappy@hub.org]
> Date d'envoi�:    vendredi 20 juin 1997 14:15
> A�:    Yann Courties
> Cc�:    'pgsql-questions@postgreSQL.org'; 'pgsql-hackers@postgreSQL.org'
> Objet�:    Re: [HACKERS] TR: Problems with Large Objects !!
>
> On Fri, 20 Jun 1997, Yann Courties wrote:
>
> > Oops forgot to mention :
> >
> > PostgreSQL version 6.1
> > Linux 2.0.30
> >
> > and it worked 'correctly' with version 5.1
>
>     Neat...there was never a v5.1 *grin*  We went from v1.09 to v6.0
>
> >
> > Thanks,
> >
> > -Yann-
> >
> > ----------
> > De :     Yann Courties
> > Date�:    jeudi 19 juin 1997 17:13
> > A :    'pgsql-hackers@postgreSQL.org'
> > Objet :    Problems with Large Objects !!
> >
> > Hi,
> >
> > I got a few problems with importing and exporting Large Object :
> >
> > CREATE TABLE test (filename text, fileid oid);
> >
> > INSERT INTO test (filename,fileid)
> >     VALUES( 'README', lo_import( '/home/postgres/README' ));
> >
> > SELECT relname FROM pgclass; --> Freeze psql
> > SELECT * FROM test;    --> is OK
> >
> > if I quit psql and then come back to it, it still has the same problem.
> > In fact the problem exists until I restart postmaster.
> > Then, after restarting posmaster, everything works fine and the file
> > README was 'correctly' imported.
> >
> > Any suggestions ??
> >
> > Regards,
> >
> > -Yann-
> >
> >
>
> Marc G. Fournier                                 scrappy@hub.org
> Systems Administrator @ hub.org              scrappy@freebsd.org
>
>

Marc G. Fournier                                 scrappy@hub.org
Systems Administrator @ hub.org              scrappy@freebsd.org

------------------------------

pgsql-hackers by date:

Previous
From: ycourties@internet.ubisoft.fr (Yann Courties)
Date:
Subject: RE: [HACKERS] TR: Problems with Large Objects !!
Next
From: "Marc G. Fournier"
Date:
Subject: Re: [HACKERS] 6.1 jumbo patch?