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

TONY J.Y. tjiang at mrf.com
Fri Dec 7 10:21:02 PST 2001


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/ 





More information about the postgis-users mailing list