On Fri, 20 Jun 1997, Yann Courties wrote:
> Oops forgot to mention :
>
> PostgreSQL version 6.1
> Linux 2.0.30
>
> and it worked 'correctly' with version 5.1
Neat...there was never a v5.1 *grin* We went from v1.09 to v6.0
>
> Thanks,
>
> -Yann-
>
> ----------
> De : Yann Courties
> Date�: jeudi 19 juin 1997 17:13
> A : 'pgsql-hackers@postgreSQL.org'
> Objet : Problems with Large Objects !!
>
> Hi,
>
> 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 ??
>
> Regards,
>
> -Yann-
>
>
Marc G. Fournier scrappy@hub.org
Systems Administrator @ hub.org scrappy@freebsd.org
------------------------------
