>
> PostgreSQL version 6.1
> Linux 2.0.30
>
> and it worked 'correctly' with version 5.1
>
> 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 ??
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?
Darren darrenk@insightdist.com
------------------------------
