Postgres Pro
Downloads
Home   >   mailing lists

DECLARE CURSOR - Mailing list pgsql-novice

From Atif Jung
Subject DECLARE CURSOR
Date
Msg-id AANLkTikODkbN8odVXr2FlMKX1Ylzx-XNMfbwiAOEqJYy@mail.gmail.com
Whole thread Raw
Responses Re: DECLARE CURSOR
List pgsql-novice
Tree view
I'm getting an error msg which reads:
 
DECLARE CURSOR can only be used in transaction blocks.
 
does that mean to DECLARE a cursor I must surrond it with a BEGIN & COMMIT work?

Atif


pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: view and column rights
Next
From: Tom Lane
Date:
Subject: Re: DECLARE CURSOR