Re: cursor "x" does not exist

2018-04-15 Thread rob stone
Hello Bob, On Sat, 2018-04-14 at 15:44 +0100, Bob Jones wrote: > Hello, > > > > P.S. As a side-question, if anyone here has experience in using > Postgres as a backend to PHP, are refcursors the way to go or should > I > be thinking of SETOF or other return styles ? > If you have a business

Re: cursor "x" does not exist

2018-04-14 Thread Adrian Klaver
On 04/14/2018 09:36 AM, Bob Jones wrote: On 14 April 2018 at 16:38, Tom Lane wrote: Bob Jones writes: My apologies if I'm being incredibly stupid here, but I've reviewed what the docs have to say about naming portals and I still can't see where I'm going wrong here ? I think you're forgetti

Re: cursor "x" does not exist

2018-04-14 Thread Bob Jones
On 14 April 2018 at 16:38, Tom Lane wrote: > Bob Jones writes: >> My apologies if I'm being incredibly stupid here, but I've reviewed >> what the docs have to say about naming portals and I still can't see >> where I'm going wrong here ? > > I think you're forgetting to double-quote an upper case

Re: cursor "x" does not exist

2018-04-14 Thread Tom Lane
Bob Jones writes: > My apologies if I'm being incredibly stupid here, but I've reviewed > what the docs have to say about naming portals and I still can't see > where I'm going wrong here ? I think you're forgetting to double-quote an upper case identifier. > FETCH ALL IN B; > ERROR: cursor "b"