Re: retun cursor
От | Oliver Elphick |
---|---|
Тема | Re: retun cursor |
Дата | |
Msg-id | 1018879322.22380.30.camel@linda обсуждение исходный текст |
Ответ на | Re: retun cursor ("Madhavi Daroor" <madhavi@zoniac.com>) |
Список | 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
Вложения
В списке pgsql-general по дате отправления: