Re: DECLARE CURSOR

On Sunday 17 November 2002 05:46 am, Frank Miles wrote:
> On Sat, 16 Nov 2002, snpe wrote:
> > On Saturday 16 November 2002 09:29 pm, Frank Miles wrote:
> > > On Fri, 15 Nov 2002, snpe wrote:
> > > > Hello,
> > > >   When I call DECLARE CURSOR out of transaction command success,
> > > > but cursor is not created
> > > >   Reference manual say that this get error :
> > > > ERROR: DECLARE CURSOR may only be used in begin/end transaction
> > > > blocks I don't find this text in pgsql source code
> > > > What is problem ?
> > >
> > > According to the documentation for DECLARE CURSOR (v.7.2.x):
> > >
> > > "Cursors are only available in transactions. Use to BEGIN, COMMIT and
> > >     ROLLBACK to define a transaction block."
> > >
> > > This seems consistent with your error message.  Please try
> > > wrapping your DECLARE inside a transaction using BEGIN,...
> >
> > I understand it.
> > I don't understand why 'DECLARE CURSOR' success out of a transaction
> > - I expect error
>
> What version are you using?  At least with 7.2.x, there is an immediate
> error at the DECLARE statement.  Perhaps I am misunderstanding your
> question?
>

7.3b5
maybe, it is prepare for cursor out of a transaction (I hope)

regards
Haris Peco