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

Paul Ramsey pramsey at refractions.net
Fri Dec 7 09:15:56 PST 2001


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/ 





More information about the postgis-users mailing list