Обсуждение: [HACKERS] TR: Problems with Large Objects !!
Oops forgot to mention :
PostgreSQL version 6.1
Linux 2.0.30
and it worked 'correctly' with version 5.1
Thanks,
- -Yann-
- ----------
De : Yann Courties
Date=A0: 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)=20
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-=09
------------------------------
>
> 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
------------------------------
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
------------------------------
RE: [HACKERS] TR: Problems with Large Objects !!
От
ycourties@internet.ubisoft.fr (Yann Courties)
Дата:
Hi,
5.1 is just what's in my PG_VERSION file ?
- -Yann-
- ----------
De : Marc G. Fournier[SMTP:scrappy@hub.org]
Date d'envoi=A0: vendredi 20 juin 1997 14:15
A=A0: Yann Courties
Cc=A0: 'pgsql-questions@postgreSQL.org'; 'pgsql-hackers@postgreSQL.org'
Objet=A0: Re: [HACKERS] TR: Problems with Large Objects !!
On Fri, 20 Jun 1997, Yann Courties wrote:
> Oops forgot to mention :
>=20
> PostgreSQL version 6.1
> Linux 2.0.30
>=20
> and it worked 'correctly' with version 5.1
Neat...there was never a v5.1 *grin* We went from v1.09 to v6.0
>=20
> Thanks,
>=20
> -Yann-
>=20
> ----------
> De : Yann Courties
> Date=A0: jeudi 19 juin 1997 17:13
> A : 'pgsql-hackers@postgreSQL.org'
> Objet : Problems with Large Objects !!
>=20
> Hi,
>=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 ??
>=20
> Regards,
>=20
> -Yann-=09
>=20
>=20
Marc G. Fournier scrappy@hub.org
Systems Administrator @ hub.org scrappy@freebsd.org
------------------------------
On Fri, 20 Jun 1997, Yann Courties wrote:
> Hi,
>
> 5.1 is just what's in my PG_VERSION file ?
Ah, okay, anyone know what version that was? Or did that include
everything from v1.01 to v1.09? :(
>
> -Yann-
>
> ----------
> De : Marc G. Fournier[SMTP:scrappy@hub.org]
> Date d'envoi�: vendredi 20 juin 1997 14:15
> A�: Yann Courties
> Cc�: 'pgsql-questions@postgreSQL.org'; 'pgsql-hackers@postgreSQL.org'
> Objet�: Re: [HACKERS] TR: Problems with Large Objects !!
>
> 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
>
>
Marc G. Fournier scrappy@hub.org
Systems Administrator @ hub.org scrappy@freebsd.org
------------------------------
RE: [HACKERS] TR: Problems with Large Objects !!
От
ycourties@internet.ubisoft.fr (Yann Courties)
Дата:
OK ok ok ok
it's version 1.09
hard week, will go to sleep very early tonight ;|
- -Yann-
- ----------
De : Marc G. Fournier[SMTP:scrappy@hub.org]
Date d'envoi=A0: vendredi 20 juin 1997 14:28
A=A0: Yann Courties
Cc=A0: 'hackers@postgreSQL.org'
Objet=A0: RE: [HACKERS] TR: Problems with Large Objects !!
On Fri, 20 Jun 1997, Yann Courties wrote:
> Hi,
>=20
> 5.1 is just what's in my PG_VERSION file ?
Ah, okay, anyone know what version that was? Or did that include
everything from v1.01 to v1.09? :(
>=20
> -Yann-
>=20
> ----------
> De : Marc G. Fournier[SMTP:scrappy@hub.org]
> Date d'envoi=A0: vendredi 20 juin 1997 14:15
> A=A0: Yann Courties
> Cc=A0: 'pgsql-questions@postgreSQL.org'; =
'pgsql-hackers@postgreSQL.org'
> Objet=A0: Re: [HACKERS] TR: Problems with Large Objects !!
>=20
> On Fri, 20 Jun 1997, Yann Courties wrote:
>=20
> > Oops forgot to mention :
> >=20
> > PostgreSQL version 6.1
> > Linux 2.0.30
> >=20
> > and it worked 'correctly' with version 5.1
>=20
> Neat...there was never a v5.1 *grin* We went from v1.09 to v6.0
>=20
> >=20
> > Thanks,
> >=20
> > -Yann-
> >=20
> > ----------
> > De : Yann Courties
> > Date=A0: jeudi 19 juin 1997 17:13
> > A : 'pgsql-hackers@postgreSQL.org'
> > Objet : Problems with Large Objects !!
> >=20
> > Hi,
> >=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 ??
> >=20
> > Regards,
> >=20
> > -Yann-=09
> >=20
> >=20
>=20
> Marc G. Fournier scrappy@hub.org
> Systems Administrator @ hub.org scrappy@freebsd.org
>=20
>=20
Marc G. Fournier scrappy@hub.org
Systems Administrator @ hub.org scrappy@freebsd.org
------------------------------
RE: [HACKERS] TR: Problems with Large Objects !!
От
ycourties@internet.ubisoft.fr (Yann Courties)
Дата:
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
------------------------------
>>>>> "Yann" == Yann Courties <ycourties@internet.ubisoft.fr> writes:
Yann> Does someone use large objects successfuly with 6.1 ?
I do. Most is through a scheme-to-PostgreSQL interface. It's been
working fine for the last week or so.
I tried you test example, and it hung, just as you said. However, I
tried again the next day, and everything worked just fine, so I'm not
sure if I have the same problem as you have.
Ray
------------------------------
RE: [HACKERS] TR: Problems with Large Objects !!
От
ycourties@internet.ubisoft.fr (Yann Courties)
Дата:
I just 'resolve' my problem by cleaning my data directory
and run initdb. Now it seems to work.
But I still can't access Postgres via MsAccess using postODBC
(I did configure pg_hba.conf)
if some one could give me a hint !
- -Yann-
- ----------
De : Raymond Toy[SMTP:toy@rtp.ericsson.se]
Date d'envoi=A0: mardi 24 juin 1997 17:56
A=A0: Yann Courties
Cc=A0: pgsql-hackers@postgreSQL.org; 'Darren King'
Objet=A0: Re: [HACKERS] TR: Problems with Large Objects !!=20
>>>>> "Yann" =3D=3D Yann Courties <ycourties@internet.ubisoft.fr> =
writes:
Yann> Does someone use large objects successfuly with 6.1 ?
I do. Most is through a scheme-to-PostgreSQL interface. It's been
working fine for the last week or so.
I tried you test example, and it hung, just as you said. However, I
tried again the next day, and everything worked just fine, so I'm not
sure if I have the same problem as you have.
Ray
------------------------------
Yann Courties wrote:
> But I still can't access Postgres via MsAccess using postODBC
> (I did configure pg_hba.conf)
What version of access are you using. If you are not using access 95
or 97 than the problem is with the odbc driver. As soon as I upgraded
to access 97 I could do normal odbc stuff. Hope this helps.
- --
Brian Weber
brian@cbiowa.com
http://www.lunix.org
------------------------------
RE: [HACKERS] TR: Problems with Large Objects !!
От
ycourties@internet.ubisoft.fr (Yann Courties)
Дата:
I am using Access95,
it works 'fine' with Postgres 1.09
but I can't make it work with Postgres 6.1
- -Yann-
- ----------
De : Brian Weber
Date=A0: mercredi 25 juin 1997 14:30
A : Yann Courties
Cc : 'Raymond Toy'; 'Darren King'; pgsql-hackers@postgreSQL.org
Objet : Re: [HACKERS] TR: Problems with Large Objects !!
Yann Courties wrote:
> But I still can't access Postgres via MsAccess using postODBC
> (I did configure pg_hba.conf)
What version of access are you using. If you are not using access 95
or 97 than the problem is with the odbc driver. As soon as I upgraded
to access 97 I could do normal odbc stuff. Hope this helps.
- --=20
Brian Weber
brian@cbiowa.com
http://www.lunix.org
------------------------------