[postgis] Why is there the limitation of PGLIB to get the cursor?

TONY J.Y. tjiang at mrf.com
Fri Dec 7 15:26:43 PST 2001


Problem solved. I just used the newest version 7.2.b2 of postgres libpq to
get connection.
Then. It works.


Thanks Dave and Paul.


Tony.

----- Original Message -----
From: "TONY J.Y." <tjiang at mrf.com>
To: <postgis at yahoogroups.com>
Sent: Friday, December 07, 2001 11:21 AM
Subject: Re: [postgis] Why is there the limitation of PGLIB to get the
cursor?


> Paul,
>
>      I have never used the precompiled library libpq.
>
>      I installed the postgressql 7.1.3. with the source-code
> postgressql7.1.3source-tar.gz on my linux box.
>      After that,  I expanded the  postgressql7.1.3source-tar.gz file in my
> client win2k box.
>      Using the      "nmake -f win32.mak"  get the win2k box Lib and DLL.
>
>     What is your meaning for your this sentence?
>         "The problem is with your *particular* copy/version of libpq on
the
> win2000 box."
>
>     What I need to do to get the correct copy/version of libpq in the
win2k
> box?
>     Looking forward to your suggestion.
>
>
> .. /tony
>
>
> ----- Original Message -----
> From: "Paul Ramsey" <pramsey at refractions.net>
> To: <postgis at yahoogroups.com>
> Sent: Friday, December 07, 2001 10:15 AM
> Subject: Re: [postgis] Why is there the limitation of PGLIB to get the
> cursor?
>
>
> > There is no limit in libpq in general, because psql *uses* libpq, and
> > you demonstrated on the linux box that it worked for you. The problem is
> > with your *particular* copy/version of libpq on the win2000 box. Time to
> > check out the source code you are working with. If you are using a
> > precompiled libpq, maybe now is the time to compile your own...
> >
> > "TONY J.Y." wrote:
> > >
> > > Dave,
> > >
> > >           I went to the linux server where the database was located.
Ran
> the
> > > psql session to declare
> > >           the big cursor and fetch all in the cursor. there was no
error
> > > there. I could declare the cursor,
> > >           and fetched all rows from the cursor.  So PostgreSQL
> server-side
> > > is OK.  The asbinary function
> > >           is OK too.
> > >
> > >           I ran my program at client side (Win2K Pro with libpq).
There
> > > came the error message when the
> > >           geom data is bigger:
> > >
> > >          "char *PQerrorMessage(const PGconn* conn);"
> > >           ********************************************************
> > >                 Error = pqReadData() --  read() failed: errno=0
> > >
> > >           ********************************************************
> > >           So there is some limit in the pqReadData() --  read() of the
C
> > > library libpq, isn't there?
> > >
> > > ../Tony
> > >
> > > ----- Original Message -----
> > > From: "Dave Blasby" <dblasby at refractions.net>
> > > To: <postgis at yahoogroups.com>
> > > Sent: Thursday, December 06, 2001 10:42 AM
> > > Subject: Re: [postgis] Why is there the limitation of PGLIB to get the
> > > cursor?
> > >
> > > > Tony,
> > > > I looked at your code and it looks like it should work.   I suggest
> you
> > > > open a "psql" session to the DB and type in all the commands that
your
> > > > program sends to the database.  When you execute the "FETCH ALL"
> > > > command, you should get an error message.
> > > >
> > > > You could also call the "char *PQerrorMessage(const PGconn* conn);"
> > > > function after the "FETCH ALL" command fails.
> > > >
> > > > Hopefully the error message will guide you as to the problem.
> > > >
> > > > The binary cursor is only limited by your machine's memory.
> > > >
> > > > dave
> > > >
> > > >
> > > > To unsubscribe from this group, send an email to:
> > > > postgis-unsubscribe at yahoogroups.com
> > > >
> > > >
> > > >
> > > > Your use of Yahoo! Groups is subject to
> http://docs.yahoo.com/info/terms/
> > > >
> > > >
> > > >
> > >
> > >
> > > To unsubscribe from this group, send an email to:
> > > postgis-unsubscribe at yahoogroups.com
> > >
> > >
> > >
> > > Your use of Yahoo! Groups is subject to
> http://docs.yahoo.com/info/terms/
> >
> > To unsubscribe from this group, send an email to:
> > postgis-unsubscribe at yahoogroups.com
> >
> >
> >
> > Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
> >
> >
> >
>
>
> To unsubscribe from this group, send an email to:
> postgis-unsubscribe at yahoogroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>


To unsubscribe from this group, send an email to:
postgis-unsubscribe at yahoogroups.com

 

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/ 





More information about the postgis-users mailing list