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
------------------------------
