Re: retun cursor - Mailing list pgsql-general

From Oliver Elphick
Subject Re: retun cursor
Date
Msg-id 1018879322.22380.30.camel@linda
Whole thread Raw
In response to Re: retun cursor  ("Madhavi Daroor" <madhavi@zoniac.com>)
List pgsql-general
On Sat, 2000-04-08 at 17:26, Madhavi Daroor wrote:
> Hi,
>    I followed the steps that you told me. An it worked fine. But I have one
> problem and that is......when I try to fetch all the resords of a table, it
> gives me the folowing error
>
> psqldb=# fetch all from "<unnamed cursor 4>";
> less: not found
>
> Why does this happen? and after I get this error, if I try to fetch fewer
> number or records say 5, then it returns 0 records.

less is a pager program.  Either install it or set PAGER=more in your
environment before running psql.

> Does this happen because there are large number of records in the cursor?

No; it is because your pager program is missing.

--
Oliver Elphick                                Oliver.Elphick@lfix.co.uk
Isle of Wight                              http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839  932A 614D 4C34 3E1D 0C1C

     "And they questioned Him, saying "...Is it lawful for
      us to pay taxes to Caesar, or not? ...And He said to
      them "...render to Caesar the things that are
      Caesar's, and to God the things that are God's."
                      Luke 20:21,22,25

Attachment

pgsql-general by date:

Previous
From: Dave Page
Date:
Subject: Re: PGAdmin
Next
From: Doug McNaught
Date:
Subject: Re: I would preffer that postgresql start with the flag -i