Re: retun cursor

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