RE: [HACKERS] TR: Problems with Large Objects !!

Hi,

No, I ran it from 'psql' command line.
the 'SELECT relname FROM pg_class' is broken
only if I have just inserted a large object ?

Does someone use large objects successfuly with 6.1 ?

By the way, I can no more interface Postgresql with MsAccess
using PostODBC driver ?
I did change the pg_hba.conf (even enabling everybody to access=20
every database did not make it work). It worked with Postgres 1.09 ?
But I can 'psql' from another Linux machine.
Is there something else to do ?

- -Yann-

- ----------
De : 	Darren King
Date=A0:	vendredi 20 juin 1997 18:04
A :	pgsql-hackers@postgreSQL.org
Objet :	Re: [HACKERS] TR: Problems with Large Objects !!

>=20
> PostgreSQL version 6.1
> Linux 2.0.30
>=20
> and it worked 'correctly' with version 5.1 (1.09)
>=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 ??

Works fine for me on 6.1 on AIX 4.1 if I "SELECT relname FROM =
pg_class;"...
                                                              ^^^^^^^^
Are you running this from a script/program of some sorts that is not =
handling
the error generated by this typo?
                        =20
                                                             =20
Darren  darrenk@insightdist.com

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