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

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

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