Hi,
5.1 is just what's in my PG_VERSION file ?
- -Yann-
- ----------
De : Marc G. Fournier[SMTP:scrappy@hub.org]
Date d'envoi=A0: vendredi 20 juin 1997 14:15
A=A0: Yann Courties
Cc=A0: 'pgsql-questions@postgreSQL.org'; 'pgsql-hackers@postgreSQL.org'
Objet=A0: Re: [HACKERS] TR: Problems with Large Objects !!
On Fri, 20 Jun 1997, Yann Courties wrote:
> Oops forgot to mention :
>=20
> PostgreSQL version 6.1
> Linux 2.0.30
>=20
> and it worked 'correctly' with version 5.1
Neat...there was never a v5.1 *grin* We went from v1.09 to v6.0
>=20
> Thanks,
>=20
> -Yann-
>=20
> ----------
> De : Yann Courties
> Date=A0: jeudi 19 juin 1997 17:13
> A : 'pgsql-hackers@postgreSQL.org'
> Objet : Problems with Large Objects !!
>=20
> Hi,
>=20
> I got a few problems with importing and exporting Large Object :
>=20
> CREATE TABLE test (filename text, fileid oid);
>=20
> INSERT INTO test (filename,fileid)=20
> VALUES( 'README', lo_import( '/home/postgres/README' ));
>=20
> SELECT relname FROM pgclass; --> Freeze psql
> SELECT * FROM test; --> is OK
>=20
> 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.
>=20
> Any suggestions ??
>=20
> Regards,
>=20
> -Yann-=09
>=20
>=20
Marc G. Fournier scrappy@hub.org
Systems Administrator @ hub.org scrappy@freebsd.org
------------------------------
